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

victor_at_hermes.cs.uh.edu ( Victor Rajendra Kumar Addepalli ) wrote:
>
> 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 |

No, dbms_sql is a 7.1 feature. Received on Mon Jul 03 1995 - 00:00:00 CEST