Re: dbms_sql
From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Wed, 17 Mar 1999 21:39:19 -0000
Message-ID: <7cp7ad$b7o$1_at_news4.svr.pol.co.uk>
Date: Wed, 17 Mar 1999 21:39:19 -0000
Message-ID: <7cp7ad$b7o$1_at_news4.svr.pol.co.uk>
Have you tried using Forms DDL instead? This is the Forms equivalent of
DBMS_SQL.
I think Reports uses SRW.DO_SQL.
If I recall correctly, using Forms DDL means that you don't have to do all that opening and closing of cursors.
Simon Hedges
Gloucester
UK
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;
>
>
Received on Wed Mar 17 1999 - 22:39:19 CET