Re: Embedded dynamic SQL

A copy of this was sent to keithejohnson_at_my-deja.com (if that email address didn't require changing) On Mon, 16 Aug 1999 22:33:29 GMT, you wrote:

>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?
>

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

>Thanks,
>Keith
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 17 1999 - 06:39:22 CDT