dbms_sql

From: E. Nunns <en201_at_cus.cam.ac.uk>
Date: 17 Mar 1999 09:29:07 GMT
Message-ID: <7cnsl3$6jm$1_at_pegasus.csx.cam.ac.uk>


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

declare

   v_cursor number;
[Quoted]    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 17 1999 - 10:29:07 CET

Original text of this message