syntax call stored procedure

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 - 17:45:36 CST