Re: PL/SQL procedure or package owner ?

From: Emmanuel <zouzou_at_yahoo.com>
Date: 14 Jan 2000 14:34:26 GMT
Message-ID: <01bf5ea5$47dace40$3601017e@EHM.cirra.fr>

Try putting the following query in your PROCEDURE/PACKAGE source code, for example :

SELECT OWNER INTO VarOwner FROM ALL_OBJECTS WHERE OBJECT_NAME='YourProcedureName'
AND OBJECT_TYPE='PROCEDURE'; and return the value of VarOwner.

Igor V. Podolsky <igoryok_at_soft-review.kiev.ua> a écrit dans l'article <AANuVVuS80m_at_soft-review.kiev.ua>...
> Emmanuel <zouzou_at_yahoo.com> wrote in message
> news:01bf5de9$6f5a1140$3601017e_at_EHM.cirra.fr...
>
> > Why don't you simply hardcode the schema name in the package/procedure
> > source code ?
>
> I do this now. But I've got quite much problems distributing my package
to
> our customers becouse they are using different schema names for our
> database. And some of them have several database versions in different
> schemas. My package should work in each.
>
> --
> Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)
>
> Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)
>
>
>
Received on Fri Jan 14 2000 - 08:34:26 CST