DBMS_SQL for PL/SQL Version 01.00.45.03.01
Date: 1996/05/10
Message-ID: <Dr746t.2t0_at_ebi.ac.uk>#1/1
Hi,
Is anyone out there using DBMS_SQL for PL/SQL Version 01.00.45.03.01 ?? Do you
know if it is working?? Is it supported??
When trying to run a Pl/SQL block containing DBMS_SQL in SQLPLUS it works
perfectly (Release 3.1.3.5.1, Oracle7 Server Release 7.1.5.2.3 , PL/SQL Release
2.1.5.2.0) . In SQLFORMS (3.0.16.12.10, Using PL/SQL Version 01.00.45.03.01) ,
when compiling doesnt allow me to use the DBMS_SQL.[V7/V6/NATIVE] constants,
neither dbms_sql.column_value for anything else than numbers, and when running
the form it doesnt return what expected for dbms_sql.fetch_rows function, and
when retrieving numbers with dbms_sql.column_value the variable where I deposit
the value queried is NULL.
I also would like to hear comments of people using DBMS_SQL within SQL*FORMS
(timing,cursors,...,) and pointers to documentaion about this package.
Thanks in advance,
Conchi
Please e-mail caminero_at_ebi.ac.uk and post (or I'll post results)
Received on Fri May 10 1996 - 00:00:00 CEST