Re: Executing a procedure from SQL Plus

the GetNames procedure is defined with two arguments, and you are only supplying one argument in the call. that's what oracle is telling you, that you have supplied only one argument.

"David Bradley" <davidbradley_at_home.com> wrote in message news:nNwy5.190248$6y5.111737743_at_news2.rdc2.tx.home.com...
> I created the package and package body below. When I call this from my
> Visual Basic app using ADO it runs fine. When I try to execute it from SQL
> Plus I get the following error. Am I doing something wrong.
>
>
> --
> Error ----------------------------------------------------------------------
> ---------
>
> SQLWKS> execute Personality.GetNames('B%');
> Personality.GetNames('B%');
> *
> ORA-06550: line 2, column 2:
> PLS-00306: wrong number or types of arguments in call to 'GETNAMES'
> ORA-06550: line 2, column 2:
> PL/SQL: Statement ignored
>
>
>
> -- Creation of package and package
> body -----------------------------------------------------------------------
> --------------
>
> CREATE OR REPLACE PACKAGE Personality
> IS
> TYPE PeopleCur IS REF CURSOR RETURN sti_personnel%ROWTYPE;
> PROCEDURE GetNames(PeopleCursor in out PeopleCur, plastname in
> sti_personnel.LAST_NAME%TYPE);
> END Personality;
>
> /
>
>
> CREATE OR REPLACE PACKAGE BODY Personality
> AS
>
> PROCEDURE GetNames(PeopleCursor in out Peoplecur, plastname in
> sti_personnel.LAST_NAME%TYPE)
> IS
> BEGIN
>
> OPEN PeopleCursor FOR
> SELECT * FROM sti_personnel WHERE LAST_NAME like plastname ;
>
> END GetNames;
>
> END Personality;
>
> /
>
>
>
> Thank you,
>
> David
>
>
>
Received on Thu Sep 21 2000 - 00:00:00 CDT