Table substitution with PRO*C Dynamic SQL
Date: 7 Jun 1993 19:52:30 GMT
Message-ID: <1v069u$jv1_at_skates.gsfc.nasa.gov>
( sqlstmt.arr, "SELECT USERNAME FROM :v1 WHERE PERSON_ID = 430");
EXEC SQL PREPARE S FROM :sqlstmt;
EXEC SQL DECLARE C CURSOR FOR S;
EXEC SQL OPEN C USING :table;
EXEC SQL FETCH C INTO :username;
/* rest of code */
:
/**********************************************************************/
I get the error: ORA-00903: invalid table name which seems to indicate the substitution is not working. The straight sql statement: SELECT USERNAME FROM PERSON WHERE PERSON_ID = 430 works fine.
Any ideas/suggestions would be appreciated.
(Oracle V6 on SGI )
Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw_at_eosdev1.gsfc.nasa.gov
Received on Mon Jun 07 1993 - 21:52:30 CEST