Re: dbms_sql

E. Nunns wrote:
>
> 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

See the other posts for workarounds ...

The problem (I think) is due to incompatibilities between PL/SQL 1 (which is what runs on 4.5) and PL/SQL 2 which is what your server is probably running..

HTH

-- 
==============================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."