Re: PLS-00306 error with simple function call within a package

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: Tue, 28 Jun 2005 23:29:11 -0400
Message-ID: <3ada6$42c2138a$471d7821$3061@ALLTEL.NET>

Texar wrote:

> On Sun, 26 Jun 2005 12:39:09 +0200, Frank van Bortel
> <frank.van.bortel_at_gmail.com> wrote:
>
>

>>Texar wrote:
>>
>>>Hello,
>>>
>>>i am trying to call a function inside a package. (basic operation)
>>>
>>>I do not have the package source and it is wrapped, so i can't see the
>>>source.
>>>
>>>the doc only say:
>>>
>>>function: opensession:
>>>
>>>in: login: varchar2
>>>pass: varchar2
>>>out: result number
>>>
>>
>>maybe the doc is wrong,
>>try:
>>
>>desc owner.package,
>>and see what the actual
>>params for the function are

>
>
>
> You are right, didn't think about the desc command under sql*plus.
> That give me the answer: result is not an out parameter but a return
> value from the fonction:
>
> so just need to exec :result :=
> owner.package.opensession('login','pass') and everything works fine by
> now.
>
> the solution is quite easy, but sometime you spend hours to figure out
> how to solve basic things :)
>
> Thank you very much.
>
> D. Texar
>

and a easy way to test a function is straight from a SELECT:

SELECT owner.package.opensession('login','pass') from DUAL;

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Tue Jun 28 2005 - 22:29:11 CDT