Re: dbms_sql

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Mon, 22 Mar 1999 11:44:03 +0200
Message-ID: <7d53cc$t08_at_grant.grant.UUCP>

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!!

PL/SQL Release 2.3... is used on server side. You can see it when
connect via SQL*Plus. But your Forms 4.5 use something like
PL/SQL Release 1.2... (see Help -> About Forms in Forms Designer Window).

This version has many difference and one of them - it can't recognize constants
from stored packages like dbms_sql.v7. I guess it finds function without parameters instead of constant.

 But you can use constant value itself, in your example

 dbms_sql.parse(v_cursor,v_string,2).

Good luck,

Leon Grinberg . leon_at_grant.kharkov.ua Received on Mon Mar 22 1999 - 10:44:03 CET