How to execute a procedure with IN OUT parameters

From: <colinleung_at_my-deja.com>
Date: Fri, 08 Sep 2000 02:15:44 GMT
Message-ID: <8p9i40$879$1@nnrp1.deja.com>

Dear All,

I am using Oracle8i (8.1.5). I have a procedure which consists of 2 IN OUT parameters. How can I execute the procedure from SQLPlus?

The procedure is as follow:

procedure ADD_CUST
 (

	id     		        in 	varchar2,
	name			in 	varchar2,
	e_code		        in out integer,
	e_message		in out varchar2
	) as .....

I have tried to execute the following commands from SQLPlus, and it returns 'PL/SQL procedure successfully completed.'

SQL> DECLARE
  2 v_e_code number;
  3 v_e_message VARCHAR2(255);
  4 BEGIN

  5  v_e_code := 0;
  6  v_e_message := 'Testing';
  7  ADD_CUST('ABC','ABC User',v_e_code,v_e_message)

  8 END;
  9 /
PL/SQL procedure successfully completed.

However I have checked there is no new record inserted to the table.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 07 2000 - 21:15:44 CDT