Re: Embedded dynamic SQL

From: <kejohnson_at_yahoo.com>
Date: Tue, 17 Aug 1999 16:02:32 GMT
Message-ID: <7pc12f$5qv$1@nnrp1.deja.com>

>
> lets see the code. without that we won't be able to get very far...
>

This is the code that I'm currently testing. Output is below.

static int qporg
{
char sql_string[1024];

EXEC SQL BEGIN DECLARE SECTION;
        varchar sql_statement[1024]; EXEC SQL END DECLARE SECTION; sprintf( sql_string,

         "SELECT ORGANIZATION_CODE FROM ORG_ORGANIZATION_DEFINITIONS"); strcpy( sql_statement.arr, sql_string); sql_statement.len= strlen( sql_statement.arr);

fprintf(efp, "Preparing...\n");
EXEC SQL AT ora_db PREPARE qporg_s from :sql_statement; if ( ! check_sqlcode( &sqlca, 1) )
{

       return 0;
}

fprintf(efp, "Declaring...\n");
EXEC SQL AT ora_db DECLARE qporg CURSOR FOR qporg_s; if ( ! check_sqlcode( &sqlca, 1) )
{

       return 0;
}

fprintf(efp, "Opening...\n");
EXEC SQL OPEN qporg;
if ( ! check_sqlcode( &sqlca, 1) )
{

       return 0;
}

                                                              275,2-16

}

The output I see when I run this is:

Preparing...
Declaring...
Opening...

SQL-02122: Invalid OPEN or PREPARE for this database connection (errno -2122)

Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 17 1999 - 11:02:32 CDT