Re: out arguments

You are right, it works. *Funny* that this works:

SQL> create or replace procedure testproc (ooo out number) is   2 l_ooo number;
  3 begin
  4 l_ooo:= ooo;
  5 end testproc;
  6 /

Procedure created.

SQL> show errors
No errors.

SQL>
SQL> variable n number
SQL> execute testproc (:n)

PL/SQL procedure successfully completed.

I always thought an out parameter is not allowed to be read. Is this an Oracle bug?

Martin

Sybrand Bakker wrote:
>
> "Rocr" <rolland.cright_at_pwgsc.gc.ca> wrote in message
> news:9e0kbt$62r1_at_shark.ncr.pwgsc.gc.ca...
> > I am importing a database that has stored procedures with OUT parameters.
> > The OUT parameters are referenced in the stored procedure:
> >
> > create or .... proc1(out_paramter OUT integer) as...
> > if some_condition = out_parameter then
> > PLS-00365: 'RECS_READ' is an OUT parameter and cannot be read.
> >
> > I can change the OUT parameters to IN OUT but I would like to find a more
> > elegant fix.
> > The source database: HP-UX 10.20 Oracle 7.3.4.1.0
> > The target database: NT sp6 Oracle 7.3.2.3.1
> >
> > Cheers
> >
> >
> >
> >
>
> declare a local variable and assign it to the out parameter when you leave
> the procedure.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
Received on Sun May 20 2001 - 23:51:09 CDT