Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: executing a procedure

Re: executing a procedure

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Sun, 2 Apr 2000 21:02:11 +0100
Message-ID: <8c9i5h$s4$4@news6.svr.pol.co.uk>


You also have to catch the output variable. Use:

SQL> var str varchar2(100);
SQL> execute str := spAddUser ('Pete', 'Rose');

or

SQL> select spAddUser('Pete','Rose') from dual;

Regards,

Gerrit-Jan Linker
Linker IT Consulting Limited
http://www.oraxcel.com

Developer of
Oraxcel, the Oracle to Excel link
OraCodes, Oracle error codes explained
OraSQL, Oracle SQL explained
OraDebug, an Oracle PL/SQL debugger.

Louis <frolio_at_videoshare.com> wrote in message news:8c84ok$ojt$1_at_bob.news.rcn.net...
> Greeting All, I have created a simple stored procedure that takes
arguments
> and
> then writes them to a new record in my user table. Below is the code for
> this procedure:
>
> CREATE OR REPLACE PROCEDURE spAddUser (
> IvcFirstName IN VARCHAR2,
> IvcLastName IN VARCHAR2,
> OvcErrorMessage OUT VARCHAR2
> )
>
> AS
> AppError EXCEPTION;
>
> BEGIN
>
> OvcErrorMessage := 'NO ERROR.';
>
> INSERT INTO VIDEOSHARE.tbUser
> VALUES(
> IvcFirstName,
> IvcLastName
> );
>
> COMMIT;
>
> EXCEPTION
> WHEN OTHERS THEN
> ROLLBACK;
> OvcErrorMessage := 'Error Inserting Record: spAddUser: Pos #1.' ||
> SQLERRM;
> RAISE AppError;
> RETURN;
> END spAddUser;
> /
>
>
> When I try to execute this procedure:
>
> execute spAddUser ('Pete', 'Rose');
>
> I am prompted with the error message:
>
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'SPADDUSER'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> I think it has to do with my output paramater? Do I need to pass
something
> to this or
> do I need to default it? Any help would be greatly appreciated.
>
> Louis
>
>
Received on Sun Apr 02 2000 - 15:02:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US