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

From: <yxfindat_at_corp02.d51.lilly.com>
Date: 1995/07/03
Message-ID: <1995Jul3.165223.1_at_corp02.d51.lilly.com>#1/1

In article <804788839.17688_at_imp.demon.co.uk>, John Thomas <John_at_toronto.demon.co.uk> writes:

You'll need Oracke 7.1

> 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