Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS-00306 error with simple function call within a package

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

From: Billy <vslabs_at_onwe.co.za>
Date: 26 Jun 2005 23:11:14 -0700
Message-ID: <1119852674.048673.201090@g47g2000cwa.googlegroups.com>


Texar wrote:

> the number of parameter is ok (i try to call the function as a
> procedure without the result parameter and i have: PLS-00221:
> 'OPENSESSION' is not a procedure or is undefined, that is what i
> expected to have (that just tell me that there is 3 parameters and i
> try to call the function as a procedure)

Do a describe on the procedure (in SQL*Plus) to verify the in/out and number of parameters. Alternatively, use TOAD and look at the ALL_ARGUMENTS datadictionary view for this procedure.

--
Billy
Received on Mon Jun 27 2005 - 01:11:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US