hello, in pl/sql code I have defined a variable:

x varchar2(100) := 'do not :1';

is it possible to change the value of x to 'do not eat' with execute
immediate and using 'eat' clauses? if so, how can it be done? if not,
why not and what are the alternatives to accomplish this?

thank you,
geos

ps. Follow-up to comp.databases.oracle.misc

On Aug 22, 5:12*pm, geos <g... (AT) nowhere (DOT) invalid> wrote:
Looks like you do not yet have a good understanding of what a bind
variable is. Here are a couple of things found using google:

http://www.akadia.com/services/ora_bind_variables.html

http://www.oracle-base.com/articles/...dVariables.php

On Aug 22, 5:12*pm, geos <g... (AT) nowhere (DOT) invalid> wrote:
To change a pl/sql variable value you just assign it a new value in an
assignment statement:

begin
.... other code
x := 'do not eat';
.... more code
end;

You use execute immediate to perform dynamic SQL, not to execute pl/
sql statements.

HTH -- Mark D Powell --

thanks for both answers!

geos