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 -> bind within functions

bind within functions

From: <felixpfrunder_at_gmx.net>
Date: 24 May 2005 00:46:38 -0700
Message-ID: <1116920798.018251.38600@g49g2000cwa.googlegroups.com>


I would like to set a bind variable within a function

I tried the following:

VARIABLE x NUMBER

CREATE OR REPLACE FUNCTION setX
RETURN NUMBER IS
BEGIN
  :x := 2;
  RETURN 0;
END;
/

but I received the syntax error

4/3 PLS-00049: bad bind variable 'X'

How have I to declar x

Thanks Received on Tue May 24 2005 - 02:46:38 CDT

Original text of this message

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