in out parameters

[jamoji]

I have a procedure with some in out variables.But I have a problem when I try to call the from SQL*Plus.I get PLS-00363 error.I work with Oracle 8.1.7.
Do I have to do something before calling the procedure with the in out variables?
Thanks

[Orca777]

Hello;
Yes;

When you have declared IN/OUT then you need to declare vars's in SQL*PLUS for every IN/OUT-parameter.

I do not know the SQL*PLUS-Syntax.
But i use always an anonymus PL/SQL-Block to test procedures:

DEFINE
-- local vars
BEGIN
-- the code
EXCEPTION WHEN OTHERS THEN
-- exeption-handling
END;
/
So i am not depending on SQL*PLUS-Syntax

Orca

[ales]

An example for SQL*Plus:

scott@oracle> create or replace procedure test
  2    (p1 in out number, p2 in out number) as
  3  a number;
  4  begin a:=p1; p1:=p2; p2:=a; end;
  5  /

Procedure created.

scott@oracle> var v1 number
scott@oracle> var v2 number
scott@oracle> exec :v1:=1; :v2:=2;

PL/SQL procedure successfully completed.

scott@oracle> exec test(:v1,:v2);

PL/SQL procedure successfully completed.

scott@oracle> print

        V1
----------
         2


        V2
----------
         1

Ales