Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling An Oracle Procedure
Davide Semprini wrote:
> Hi,
>
> you cannot exec a procedure from sqlplus that return OUT parameter.
> This is done for prevent using function or procedure with OUT or REFERENCE
> parameter
> inside SQL commands.
>
>
> D.
Actually you can:
CREATE OR REPLACE PROCEDURE out_param (
mesg OUT VARCHAR2) IS
BEGIN
mesg := 'Single OUT Parameter';
END out_param;
/
set serveroutput on
DECLARE
s VARCHAR2(50);
BEGIN
out_param(s);
dbms_output.put_line(s);
END;
/
But I will acknowledge ... not directly.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Nov 06 2004 - 07:08:04 CST
![]() |
![]() |