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

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling An Oracle Procedure

Re: Calling An Oracle Procedure

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Nov 2004 05:08:04 -0800
Message-ID: <1099746416.652455@yasure>


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

Original text of this message

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