DYNAMIC SQL in PL/SQL 2.0/ORACLE 7.0.16 *HELP*

From: Victor Rajendra Kumar Addepalli <victor_at_hermes.cs.uh.edu>
Date: 1995/06/30
Message-ID: <3svhhh$f6o_at_masala.cc.uh.edu>#1/1


In article <tssmithDAy6qn.6Jw_at_netcom.com>, Tim Smith <tssmith_at_netcom.com> wrote:
>"J. Herman Elenbaas" <elenbaas_at_prl.philips.nl> writes:
>>Dynamical SQL in PL/SQL is possible via the dbms_sql routines (
>>dbms_sql.open_cursor, dbms_parse and dbms_sql.close_cursor).
 

>>An example is given in the booklet "PL/SQL Release 2.1 and Oracle
>>precompilers 1.6 addendum" and on http://gserver.grads.vt.edu/.
>
>Also look in the Application Developer's Guide, if you have 7.1 or
>later. The dynamic SQL routines are documented there.
>

I am running PL/SQL 2.0 under ORACLE 7.0.16 and I tried the "dbms_sql.function()' in PL/SQL block. I have problem getting it compilied, and the error message is:

  cur := dbms_sql.open_cursor;

                  *

ERROR at line 13:
ORA-06550: line 13, column 19:
PLS-00201: identifier 'DBMS_SQL.OPEN_CURSOR' must be declared
ORA-06550: line 13, column 3:

PL/SQL: Statement ignored
ORA-06550: line 15, column 39:
PLS-00201: identifier 'DBMS_SQL.V7' must be declared
ORA-06550: line 15, column 3:


I am wondering if the 'dbms_sql.function()' feature is supported in ORACLE 7.0.16, for PL/SQL 2.0. Thanks for the above help, and appreciate any further pointers.

Victor Addepalli/..

-- 
=========================================================================
| Victor Addepalli             :  Dept. of Comp. Sc., Univ. of Houston  |
| e-mail : victor_at_cs.uh.edu    :  University Park, Houston, TX - 77204  |
| US-mail: 4371 Faculty Lane, Houston, TX - 77004                       |
Received on Fri Jun 30 1995 - 00:00:00 CEST

Original text of this message