DBMS_SQL.PARSE does not work after Oracle8 upgrade

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: Thu, 28 Oct 1999 10:19:52 -0400
Message-ID: <7v9mfd$h25$1@bgtnsc03.worldnet.att.net>

Thanks in advance for any help you may provide. Yesterday we upgraded from Oracle 7.3.4 to Oracle 8.0.5. Now our dynamic SQL function does not work.

This is where I bomb:

dbms_output.put_line('*** About to SQL parse for table: '); DBMS_SQL.PARSE (cursor_handle,

                   'SELECT ' || col_string ||
                   '  FROM ' || in_table_name,
                DBMS_SQL.V7);

dbms_output.put_line('*** Made it!');

This is the result::
*** About to SQL parse for table: CONNECTICARE_RX 5ORA-00923: FROM keyword not found where expected

What should I do or try? Changing DBMS_SQL.V7 to DBMS_SQL.V8 did not work. It said we had to define a string for V8.

Thanks Again,
Frank S.
New Hampshire Received on Thu Oct 28 1999 - 09:19:52 CDT