Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> bind within functions
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