Phenomenon concerning dbms_sql

From: Wolfgang Roehl <Wolfgang.Roehl_at_dlr.de>
Date: 1997/11/11
Message-ID: <3468812F.FB2CC49C_at_dlr.de>#1/1


Hi,
[Quoted] [Quoted] now I know how to use dynamic SQL with the dbms_sql package. [Quoted] 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". When I look to my dbms_sql packages with svrmgrm (unix) they are marked as valid. [Quoted] But when trying to descibe the dbms_sql package in the worksheet I get the message "object to be described does not exist". However the enterprise manager tool "schema manager" is able to descibe the package.

Any suggestions how to solve this conflict?

Thanks in advance.

Wolfgang R.

-- 


////////////////////////////////////////////////////////////////////////
/ DLR, Central Data Processing Division /
/ __/|__ Wolfgang Roehl
/
/ /_/_/_/ Lilienthalplatz 7 /
/ |/ D-38108 Braunschweig /
/ Telephone: ++49 (0)531-295-2789, Fax ++49 (0)531-295-2880 /
////////////////////////////////////////////////////////////////////////
Received on Tue Nov 11 1997 - 00:00:00 CET

Original text of this message