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

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 Received on Sun Jun 26 2005 - 06:47:30 CDT