Re: dbms_sql

From: Isaias M. Gutierrez <igutierr_at_mail.sdsu.edu>
Date: Tue, 23 Mar 1999 15:02:25 -0800
Message-ID: <36F81D81.51C93A93_at_mail.sdsu.edu>

All good advice so far.  Also, try using:

v_cursor cursor_handle;

instead of the declaration below, and see if that helps.  --Isaias

Attemping to use dbms_sql within forms 4.5 I have the following
pl/sql error:-

declare
   v_cursor number;
   v_string varchar2(200) := 'select id from xx_table;';
begin
   v_cursor := dbms_sql.open_cursor;
   dbms_sql.parse(v_cursor,v_string,dbms_sql.v7);
end;

Error 302 component V7 must be declared

The version of pl/sql I am using is 2.3.  Isn't V7 a constant declared
within the dbms_sql package?  Suggestions gratefully received!!

Elaine

Received on Wed Mar 24 1999 - 00:02:25 CET