RE: exec immediate
exec immediate -- Igor Neyman 2006-01-24
Multiple errors in your code.
This will work:
set serveroutput on
execute immediate 'select sysdate from dual' into
Read Oracle docs.
when the below is run i am getting the error. can someone help me :
execute immediate ' select sysdate from dual ;'
ERROR at line 3:
ORA-06550: line 3, column 1:
Encountered the symbol "END" when expecting one of the following:
. ( * @ %
& = - + ; < / > at in is mod not rem return
exponent (**)> <> or != or ~= >= <= <> and or
between into using || bulk
The symbol ";" was substituted for "END" to
What are the most popular cars? Find out at Yahoo!