Re: Phenomenon concerning dbms_sql
Date: 1997/11/13
Message-ID: <01bcf00b$22c9faa0$150114c1_at_sparta>#1/1
Hi, Wolfgang !
> But now I've got a phenomenon. If I use the dbms_sql.v7 constant I
> receive an error message "component 'v7' must be declared".
I suggest you can't see constants from stored packages at all. It's feature from PL/SQL Release 2. Even Oracle native SQL*Forms 3.0, Oracle*Forms 4.5 and others can't recognize such constants because they include PL/SQL Release 1. Also you can't use it in SQL statements. I guess they search function dbms_sql.v7, not a constant!
> But when trying to descibe the dbms_sql package in the worksheet I get
> the message "object to be described does not exist".
You don't say what tool is your "worksheet". But I suppose you must use '2' instead of dbms_sql.v7. Received on Thu Nov 13 1997 - 00:00:00 CET