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

Home -> Community -> Usenet -> c.d.o.misc -> Re: bind within functions

Re: bind within functions

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 24 May 2005 00:59:02 -0700
Message-ID: <1116921542.586199.299850@f14g2000cwb.googlegroups.com>


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

Original text of this message

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