Re: Phenomenon concerning dbms_sql

I had problems doing the same from forms. Instead of passing (dbms_sql.native) I passed the value which I needed. DBMS_SQL.NATIVE is defined as a (constant integer := 1), DBMS_SQL.V7 is defined as (constant integer := 2). I passed a 1. This allowed my package to compile and execute. This is probably not a good idea but I needed it to work. I'll have to watch upgrades and make sure it still does what I want it to.

Steve J.

Wolfgang Roehl wrote:
>
> 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