Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: bind within functions
SQL> CREATE OR REPLACE PROCEDURE setX (p_x IN OUT NUMBER )
2 is
3 BEGIN
4 p_x := 2;
5 END;
6 /
Procedimiento creado.
SQL> VARIABLE x NUMBER
SQL> EXEC setX(:x);
Procedimiento PL/SQL terminado correctamente.
SQL> print x
X
2
Cheers. Received on Tue May 24 2005 - 02:59:02 CDT