EXECUTE IMMEDIATE won't work at all [Archive]

View Full Version : EXECUTE IMMEDIATE won't work at all

waldemar

12-13-01, 13:36

HELP!! This is crazy, at last I found the Oracle-eval() but it just doesnt work!!

EXECUTE IMMEDIATE 'BEGIN HTP.P("test"); END;';

Whats wrong with this code???
Any hints appreciated...
waldemar

jade001

12-14-01, 19:19

I'm not sure exactly what your code means, but I can tell you this...

If you try to use a query in EXECUTE IMMEDIATE, it can only return one value. It is not quite as simple as an eval() method is in some languages. If your query returns more than one value you have to use PARSE and BIND all variables you are using in the statement.

Hope that helps, and maybe one of the gurus on this board can expand on that a bit.

jade

waldemar

12-15-01, 04:56

Thanks, I understand this is for queries.

But I'm using execute immediate with a pl/sql block. In all references I found this code (enclosing in begin/end) to work... I'm puzzled it doesnt on my machine...

gavin

12-15-01, 08:51

Originally posted by waldemar
HELP!! This is crazy, at last I found the Oracle-eval() but it just doesnt work!!

EXECUTE IMMEDIATE 'BEGIN HTP.P("test"); END;';

Whats wrong with this code???
Any hints appreciated...
waldemar

ppppp

gavin

12-15-01, 08:52

Originally posted by gavin

ppppp

pppp

gavin

12-15-01, 08:52

Originally posted by gavin

pppp

pppp