Re: syntax call stored procedure

You have the correct syntax for a procedure that is expecting only 3 input params, but since you declared the others IN/OUT, oracle is expecting you to provide the other ones also. If they are indeed just OUT params, declare them as such, and life can go on.;-)

cindy

henry wrote:

> Hi,
> This maybe a silly question to ask, but I'm new
> to Oracle.
>
> I have a stored procedure which takes 3 parameters.
> It is:
> SQL> DESC SPMMGETCONFINFO
> PROCEDURE SPMMGETCONFINFO
> Argument Name Type In/Out Default?
> ------------------------------ ----------------------- ------ --------
> LOCATIONNAME VARCHAR2 IN
> ZONENAME VARCHAR2 IN
> CONFID NUMBER IN
> RC1 REF CURSOR IN/OUT
> RECORD IN/OUT
> CONFID NUMBER(10) IN/OUT
> CONFNAME VARCHAR2(300) IN/OUT
> ZONENAME VARCHAR2(128) IN/OUT
> LOCATIONNAME VARCHAR2(128) IN/OUT
> CBSERVERADDR VARCHAR2(64) IN/OUT
> WEBSERVERADDR VARCHAR2(64) IN/OUT
> TELEPHONYENABLED NUMBER(10) IN/OUT
> LOCKED NUMBER(10) IN/OUT
> STATUS NUMBER(10) IN/OUT
> REMOTESTATUS NUMBER(10) IN/OUT
> MEETINGKEY NUMBER(10) IN/OUT
> MEETINGKEYSET NUMBER(10) IN/OUT
> CONFFLAGS NUMBER(10) IN/OUT
> CONFFLAGSSET NUMBER(10) IN/OUT
> LOCALCBSERVERADDR VARCHAR2(64) IN/OUT
>
> In MS SQL7, I use the following syntax:
>
> EXEC SPMMGETCONFINFO 'HENRY', 'SF', 1
>
> In Oracle, I use the following syntax:
>
> EXEC SPMMGETCONFINFO('HENRY', 'SF', 1)
>
> But I always get the following error message:
>
> SQL> exec spmmgetconfinfo('henry', 'sf', 1)
> BEGIN spmmgetconfinfo('henry', 'sf', 1); END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call
> to 'SPMMGETCONFINFO'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> What's the correct syntax for the stored procedure?
>
> Thanks very much!
>
> --
> henry
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 09 1999 - 19:03:29 CST