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

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.

<felixpfrunder (AT) gmx (DOT) net> wrote

I'm just an occasional dabbler in PL/SQL (and someone
will no doubt correct me if I'm wrong), but AFAIK, all
PL/SQL variables are naturally bind variables, so there
is no need for explicit qualification, unless using
dynamic SQL, IIRC.

Cheers,
Chris Val

Chris ( Val ) wrote:
Correct. There is no value in doing what was done above
except in NDS.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)