
November 30th, 2003, 06:57 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Posts: 68
Time spent in forums: < 1 sec
Reputation Power: 10
|
|
|
The following worked for me in SQL*Plus:
SQL> create procedure tst(va in out number,n out varchar2)
as
begin
dbms_output.put_line('Testing...');
dbms_output.put_line('Enter age ');
va:=28;
end;
SQL> set serveroutput on
No semi-colon at the end, since it's an SQL*Plus command
SQL> var x number
SQL> var y varchar2
SQL> exec tst(:x,:y);
Testing...
Enter age
PL/SQL procedure successfully completed.
regards,
Dan
|