Re: Phenomenon concerning dbms_sql

From: Roy Klassen <rklassen_at_pei.sympatico.ca>
Date: 1997/11/17
Message-ID: <64pstg$bs8$1_at_news21.bellglobal.com>#1/1


I've seen this problem before, but it was with a table. When we used DBMS_SQL, we got the Object does not exist eror on a table.

What the problem was that the table was corrupt. What we did to fix the problem was drop the table and re-create it. I assume you could probably do the same thing for your v7 procedure.

Roy Klassen rklassen_at_pei.sympatico.ca

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 Mon Nov 17 1997 - 00:00:00 CET

Original text of this message