DBMS_SQL for PL/SQL Version 01.00.45.03.01

From: Concepcion Merino-Caminero <caminero>
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

Original text of this message