Re: syntax call stored procedure

As you have a big number of in out parameters, you need to use host variables or Pl/sql variables for ALL those parameters. So need to add ALL of them to your call of this procedure.

Hth

--
Sybrand Bakker, Oracle DBA
henry <henryc_at_activetouch.com> wrote in message news:82pf18$qv9$1_at_nnrp1.deja.com...
> 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 Fri Dec 10 1999 - 14:07:47 CST