Re: Stored Procedures errors when calling...
Date: 24 Jan 2003 22:17:58 -0800
Message-ID: <92eeeff0.0301242217.1c538054_at_posting.google.com>
thebigvalbosky_at_hotmail.com (Jeff Reed) wrote in message news:<efc0dbf9.0301241249.4bbcc426_at_posting.google.com>...
> ...but not when compiling.
>
> I am using Oracle 8.1.6.
>
> I have created a stored procedure to return one value.
If you look closely, you have answered your own problem. You have an OUT parameter in your procedure but you have not provided an OUT variable to recieve the value. Furthermore, you would need to set serverout environment to on to be able to view the value in sqlplus. e.g.
SQL> set serverout on
SQL> declare
1 return_val_ NUMBER;
2 begin
3 getremainingmyrate(return_val_);
4 dbms_output.put_line(to_char(return_val_));
5 end;
6 /
Regards
/Rauf Sarwar
Received on Sat Jan 25 2003 - 07:17:58 CET