Home -> Usenet -> comp.databases.oracle -> Declare Cursor for 2nd DB Connection

Declare Cursor for 2nd DB Connection

From: Carl Hoang <choang_at_tdkt.mn.org>
Date: Thu, 8 Dec 1994 22:37:12 GMT
Message-ID: <1994Dec8.223712.2596_at_tdkt.mn.org> 






I'm using Pro*C 1.5.9.0.1.  I'm getting a PCC-W-0045 message for this SQL
statement:


        EXEC SQL AT my_db DECLARE my_cursor CURSOR FOR my_sql;
Somehow it doesn't like "AT" and ignores it and goes on with the
compilation.  During the executable, it fails and should because I'm asking
for a specific non-default DB.  Do you have a suggestion on how to fix this
err?  Thanks.


        Carl Hoang	choang_at_tdkt.mn.org
Received on Thu Dec 08 1994 - 23:37:12 CET












Original text of this message