Embedded dynamic SQL

From: <keithejohnson_at_my-deja.com>
Date: Mon, 16 Aug 1999 22:33:29 GMT
Message-ID: <7pa3jp$rhj$1@nnrp1.deja.com>

I am trying to write a very *simple* query using dynamic SQL in a Pro*C program. I am running against Oracle 7 and the program which I am modifying is compiled with the DBMS=V6_CHAR option. This is the first dynamic SQL used in this program.

I am currently using a statement similar to: "SELECT COL FROM TABLE" without a where clause or any other extraneous info.

My PREPARE executes successfully, as does my DECLARE CURSOR. when I perform the OPEN call, I get the following error message:

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

I can't find an explanation of this code and/or message anywhere in my documentation. If I execute the same statement as regular embedded SQL, it works fine.

Can anyone offer some help to me?

Thanks,
Keith

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 16 1999 - 17:33:29 CDT