X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 01C763A5D1B for ; Wed, 12 Jan 2005 16:04:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35817-01 for ; Wed, 12 Jan 2005 16:04:34 +0000 (GMT) Received: from zeus.w2k.nrlmry.navy.mil (zeus.w2k.nrlmry.navy.mil [199.9.2.132]) by svr1.postgresql.org (Postfix) with ESMTP id 84DEE3A5D04 for ; Wed, 12 Jan 2005 16:04:31 +0000 (GMT) content-class: urn:content-classes:message Subject: ECPG and CURSOR declaration MIME-Version: 1.0 Date: Wed, 12 Jan 2005 08:04:24 -0800 Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=SHA1; boundary="----=_NextPart_000_034E_01C4F87D.590D2290" X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 Message-ID: <5188F15076BC7A4DBB705747602058C11AA6D1@mailhost> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: ECPG and CURSOR declaration Thread-Index: AcT4wGcrTkx0892vQyS3DiBQuTjqKg== From: "Frost, Mr. Michael (contractor)" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.581 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200501/7 X-Sequence-Number: 5233 This is a multi-part message in MIME format. ------=_NextPart_000_034E_01C4F87D.590D2290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi All. The following code compiles and works fine on 7.3. However, with 7.4 it doesn't make it through the compiler. With 7.4 it seems to want the cursor declare to be in the same subroutine as the fetch. ======================================================================== =========== #include void driver ( ) { void prepareIt ( char * ); EXEC SQL BEGIN DECLARE SECTION; char sElect_G[2048]; long lSubCenter_L, lProductionCenter_L, lModel_L, lGrid_L; char szModelName_L[64]; char szProductCenterName_L[64]; EXEC SQL END DECLARE SECTION; sprintf ( sElect_G, "SELECT %s %s FROM MDGRIDModels, MDGRIDProdCenters WHERE MDGRIDModels.centerID = MDGRIDProdCenters.centerID AND MDGRIDModels.subcenterID = MDGRIDProdCenters.subcenterID", "MDGRIDModels.centerID, MDGRIDModels.subcenterID,", "generatingProc, gridID, modelName, productionCenter"); prepareIt ( sElect_G ); EXEC SQL FETCH CUR4LL INTO :lProductionCenter_L, :lSubCenter_L, :lModel_L, :lGrid_L, :szModelName_L, :szProductCenterName_L; } void prepareIt ( char *myString ) { EXEC SQL BEGIN DECLARE SECTION; char sElect_G[2048]; EXEC SQL END DECLARE SECTION; EXEC SQL PREPARE sQLstatement FROM :sElect_G; EXEC SQL DECLARE CUR4LL CURSOR FOR sQLstatement; EXEC SQL OPEN CUR4LL; } ======================================================================== ========= Thanks, Michael Frost ------=_NextPart_000_034E_01C4F87D.590D2290 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIM8jCCBBsw ggOEoAMCAQICARMwDQYJKoZIhvcNAQEFBQAwYTELMAkGA1UEBhMCVVMxGDAWBgNVBAoTD1UuUy4g R292ZXJubWVudDEMMAoGA1UECxMDRG9EMQwwCgYDVQQLEwNQS0kxHDAaBgNVBAMTE0RvRCBDTEFT UyAzIFJvb3QgQ0EwHhcNMDAwODExMTc0NTI5WhcNMDYwODEwMTc0NTI5WjBkMQswCQYDVQQGEwJV UzEYMBYGA1UEChMPVS5TLiBHb3Zlcm5tZW50MQwwCgYDVQQLEwNEb0QxDDAKBgNVBAsTA1BLSTEf MB0GA1UEAxMWRE9EIENMQVNTIDMgRU1BSUwgQ0EtMzCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC gYEA73y9yGvr8S43hXDaHWi/OIgHM6aXzwsq2I1DEwU3TslXTgkVHaRm247GUJy82cvZ9e/2VEbi 16LCoGV23fp6RVj/UsORbrEN5y8edLgG4mFA+eYx2e4cXjtPArs79vG968Aqkp5LX+zDXC7Iok30 GLuN7MffqBj4J1P1XB8/hAkCAwEAAaOCAd4wggHaMB0GA1UdDgQWBBTsE1u8IYxmmwqLfwdfJbAU +RD1mzAOBgNVHQ8BAf8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAMBgNVHSQEBTADgAEAMB8GA1Ud IwQYMBaAFGycpfBcj21BjcQXO5BXwg+jzW3+MDAGA1UdIAQpMCcwCwYJYIZIAWUCAQsFMAsGCWCG SAFlAgELCTALBglghkgBZQIBCwowgYMGA1UdEgR8MHqGeGxkYXA6Ly9kcy0zLmMzcGtpLmNoYW1i LmRpc2EubWlsL2NuJTNkRG9EJTIwQ0xBU1MlMjAzJTIwUm9vdCUyMENBJTJjb3UlM2RQS0klMmNv dSUzZERvRCUyY28lM2RVLlMuJTIwR292ZXJubWVudCUyY2MlM2RVUzCBsAYDVR0fBIGoMIGlMIGi oIGfoIGchoGZbGRhcDovL2RzLTMuYzNwa2kuY2hhbWIuZGlzYS5taWwvY24lM2REb0QlMjBDTEFT UyUyMDMlMjBSb290JTIwQ0ElMmNvdSUzZFBLSSUyY291JTNkRG9EJTJjbyUzZFUuUy4lMjBHb3Zl cm5tZW50JTJjYyUzZFVTP2NlcnRpZmljYXRlcmV2b2NhdGlvbmxpc3Q7YmluYXJ5MA0GCSqGSIb3 DQEBBQUAA4GBACaljTU4dmv+9EEmyDEZRft2IawIavNgzULR+GsmScfgvsubrU23VtJnj+hseOVD EFDIPH2i8hIECL/9NVR3VQpt2o1bsieyjZ6eYr1t4b14rkzRl8R2PdLRTGYkCBFdKBWycTvHM/e5 nX+YnH76BLByl37808FUk2MUk9/xG8vgMIIEQDCCA6mgAwIBAgIDFWV6MA0GCSqGSIb3DQEBBQUA MGQxCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNVBAsTA0RvRDEM MAoGA1UECxMDUEtJMR8wHQYDVQQDExZET0QgQ0xBU1MgMyBFTUFJTCBDQS0zMB4XDTAzMDYwOTAw MDAwMFoXDTA2MDYwODAwMDAwMFowgYExCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVy bm1lbnQxDDAKBgNVBAsTA0RvRDEMMAoGA1UECxMDUEtJMRMwEQYDVQQLEwpDT05UUkFDVE9SMScw JQYDVQQDEx5GUk9TVC5NSUNIQUVMLkRBVklELjExOTgzODQ5NDgwgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBAMyjbYxyiCnVfeNQ/u6cAxJLqMXQbr8nFjSp+xF0VT6bb9hKu5em4QosLQkpEXsO j//lQqzsZpzmiaos88jV1rb2obJCV2Syhqd/oPuE4YL8uatn2gp2PVXwfTVfGHMfeABuD/QMS1cq VGay0RB7d31m5XHugMy2X8mClO1l6RnTAgMBAAGjggHgMIIB3DAOBgNVHQ8BAf8EBAMCBSAwJAYD VR0RBB0wG4EZZnJvc3QuY3NjQG5ybG1yeS5uYXZ5Lm1pbDAfBgNVHSMEGDAWgBTsE1u8IYxmmwqL fwdfJbAU+RD1mzAdBgNVHQ4EFgQU+xrDudyhjyztOeEPzLvFgfAOMWYwFgYDVR0gBA8wDTALBglg hkgBZQIBCwkwgY8GA1UdEgSBhzCBhIaBgWxkYXA6Ly9lbWFpbC1kcy0zLmMzcGtpLmNoYW1iLmRp c2EubWlsL2NuJTNkRE9EJTIwQ0xBU1MlMjAzJTIwRU1BSUwlMjBDQS0zJTJjb3UlM2RQS0klMmNv dSUzZERvRCUyY28lM2RVLlMuJTIwR292ZXJubWVudCUyY2MlM2RVUzCBuQYDVR0fBIGxMIGuMIGr oIGooIGlhoGibGRhcDovL2VtYWlsLWRzLTMuYzNwa2kuY2hhbWIuZGlzYS5taWwvY24lM2RET0Ql MjBDTEFTUyUyMDMlMjBFTUFJTCUyMENBLTMlMmNvdSUzZFBLSSUyY291JTNkRG9EJTJjbyUzZFUu Uy4lMjBHb3Zlcm5tZW50JTJjYyUzZFVTP2NlcnRpZmljYXRlcmV2b2NhdGlvbmxpc3Q7YmluYXJ5 MA0GCSqGSIb3DQEBBQUAA4GBAJlQGMGXSR7RJ8nmXZj25TbtCh+YYToNI/6V8rZDJ2W3MICnny28 I0TwvxFiEY1G7TcProIaTTOSdXqgalTcE/iOImszHyvUFA1nw4zLOaCYS9yqF5TR72/sVv+4pIPb 1pnCsujyS6/hoHUtuFNBZ/x08gMxX631taKraOWA1JG7MIIEizCCA/SgAwIBAgIDFWV1MA0GCSqG SIb3DQEBBQUAMGQxCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9VLlMuIEdvdmVybm1lbnQxDDAKBgNV BAsTA0RvRDEMMAoGA1UECxMDUEtJMR8wHQYDVQQDExZET0QgQ0xBU1MgMyBFTUFJTCBDQS0zMB4X DTAzMDYwOTAwMDAwMFoXDTA2MDYwODAwMDAwMFowgYExCzAJBgNVBAYTAlVTMRgwFgYDVQQKEw9V LlMuIEdvdmVybm1lbnQxDDAKBgNVBAsTA0RvRDEMMAoGA1UECxMDUEtJMRMwEQYDVQQLEwpDT05U UkFDVE9SMScwJQYDVQQDEx5GUk9TVC5NSUNIQUVMLkRBVklELjExOTgzODQ5NDgwgZ8wDQYJKoZI hvcNAQEBBQADgY0AMIGJAoGBAJDhyeM/vz4OKgaU2A7GQXTRGIv0biyHBsyuC9YeW0o0MEIfT/oZ DJFEJRRogcnVF/GmYudix0NHuLS/XyQnVKaP4lmkbuXWRsMEbfCMSEHOiCnmIw4v9M49PjdD1x5I Z0j48U6ialENVTOnKuBfaLAomRliupQqajSmGnSba5OTAgMBAAGjggIrMIICJzAOBgNVHQ8BAf8E BAMCBsAwHwYDVR0jBBgwFoAU7BNbvCGMZpsKi38HXyWwFPkQ9ZswHQYDVR0OBBYEFJZ496wcsHpk u7ZHulSCACsOu3xvMBYGA1UdIAQPMA0wCwYJYIZIAWUCAQsJMIGPBgNVHRIEgYcwgYSGgYFsZGFw Oi8vZW1haWwtZHMtMy5jM3BraS5jaGFtYi5kaXNhLm1pbC9jbiUzZERPRCUyMENMQVNTJTIwMyUy MEVNQUlMJTIwQ0EtMyUyY291JTNkUEtJJTJjb3UlM2REb0QlMmNvJTNkVS5TLiUyMEdvdmVybm1l bnQlMmNjJTNkVVMwgbkGA1UdHwSBsTCBrjCBq6CBqKCBpYaBomxkYXA6Ly9lbWFpbC1kcy0zLmMz cGtpLmNoYW1iLmRpc2EubWlsL2NuJTNkRE9EJTIwQ0xBU1MlMjAzJTIwRU1BSUwlMjBDQS0zJTJj b3UlM2RQS0klMmNvdSUzZERvRCUyY28lM2RVLlMuJTIwR292ZXJubWVudCUyY2MlM2RVUz9jZXJ0 aWZpY2F0ZXJldm9jYXRpb25saXN0O2JpbmFyeTApBgNVHSUEIjAgBgorBgEEAYI3FAICBggrBgEF BQcDBAYIKwYBBQUHAwIwRAYDVR0RBD0wO4EZZnJvc3QuY3NjQG5ybG1yeS5uYXZ5Lm1pbKAeBgor BgEEAYI3FAIDoBAMDjExOTgzODQ5NDhAbWlsMA0GCSqGSIb3DQEBBQUAA4GBAA0TfZt/LsgUohxw v8DuXOcayOJ6gzjyRG01eqkUqLe0TKZYxjwpY11Y9Xn4/hrw+m5R9uznuiJQZy8YU5RKoxYYKeEc 4gCefqKOIyQePTJFVsD+Bti2yJFNp8EXvHg0MKXMvOBlV/QoJnx8t2gpIi14090xMZixlBMTD5cc JXbpMYICIzCCAh8CAQEwazBkMQswCQYDVQQGEwJVUzEYMBYGA1UEChMPVS5TLiBHb3Zlcm5tZW50 MQwwCgYDVQQLEwNEb0QxDDAKBgNVBAsTA1BLSTEfMB0GA1UEAxMWRE9EIENMQVNTIDMgRU1BSUwg Q0EtMwIDFWV1MAkGBSsOAwIaBQCgggEOMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZI hvcNAQkFMQ8XDTA1MDExMjE2MDQzMlowIwYJKoZIhvcNAQkEMRYEFLzEGh++tYOXQFjOTBEEDS48 qSy+MDMGCSqGSIb3DQEJDzEmMCQwDQYIKoZIhvcNAwICASgwBwYFKw4DAhowCgYIKoZIhvcNAgUw egYJKwYBBAGCNxAEMW0wazBkMQswCQYDVQQGEwJVUzEYMBYGA1UEChMPVS5TLiBHb3Zlcm5tZW50 MQwwCgYDVQQLEwNEb0QxDDAKBgNVBAsTA1BLSTEfMB0GA1UEAxMWRE9EIENMQVNTIDMgRU1BSUwg Q0EtMwIDFWV6MA0GCSqGSIb3DQEBAQUABIGAFoDX0YjGgrgL/7JF5VL5ovcN8H3Oorwv8y774PhP M3tkX5zycYvag1ZXnoaarRQGEnmH07qtMr2cvfDkEOM2Y0f36B0xa8gUEapLv2W/vsnGrrZebwl0 u+gqQNwEdewvqKIVVGDI35ChwFTWk6UjsKWIttfnlrZgO7dE+RdVpRUAAAAAAAA= ------=_NextPart_000_034E_01C4F87D.590D2290--