Re: Phenomenon concerning dbms_sql

I've seen this exact same problem, but cannot remember what we did to fix it. What version Oracle?

Troy Fruetel
[Connect]

Wolfgang Roehl wrote in message <3468812F.FB2CC49C_at_dlr.de>...
>Hi,
>now I know how to use dynamic SQL with the dbms_sql package.
>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.
>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