DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1099746416.652455_at_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.
Thank's for replying so quickly. I'm going to follow your example you
were a big help thank's again. It seems like I have a long way to go.
Received on Mon Nov 08 2004 - 08:36:22 CST
