Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Executing a procedure from SQL Plus
I have tried all kinds of ways to execute this. My procedure should return all rows from a table where the LAST_NAME is like the passed parameter. The procedure works fine when called from my VB app. Could you give me the syntax to execute this in SQL Plus window with the declaration of the variables?
Thanks,
David
Carl Hathaway <chathaw2_at_ford.com> wrote in message
news:8qf29k$4nj7_at_eccws12.dearborn.ford.com...
> Additionally as the first parameter is an IN OUT then you need to declare
a
> variable to hold the returning value.
>
> spencer <spencerp_at_swbell.net> wrote in message
> news:Lhyy5.830$p67.84632_at_nnrp2.sbc.net...
> > 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 ----------------------------------------------------------------------> > > -- Creation of package and package
> > > ---------
> > >
> > > 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
> > >
> > >
> > >
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
> > >
> > >
> > >