Re: syntax call stored procedure

The problem is:
I used the Oracle Migration WorkBench to Migrate a MS SQL7 database to Oracle8. After the Migration, all stored procedures got a new required parameter RC1.
Is there any way to get rid of this RC1?

-Henry

In article <38505182.361656EF_at_rationalconcepts.com>,   "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:
> 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.
>
>

--
henry

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 15:56:29 CST