Re: dbms_sql

I'd the same problem. I've found a workaround... I've replace the constant 'dbms_sql.v7' by the value 2

• dbms_sql.parse(v_cursor,v_string,2)- (Oracle documentation say that the constant v7 of package dbms_sql contain (should...) the value 2)

regards

Cédric

E. Nunns wrote in message <7cnsl3$6jm$1_at_pegasus.csx.cam.ac.uk>...
>
>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 17 1999 - 12:38:20 CET