Oracle 8.0.4.0.0 : Exec or DBMS_SQL ? [message #8116] |
Mon, 28 July 2003 03:25 |
Gerald
Messages: 54 Registered: January 2001
|
Member |
|
|
Thank you barbara for you help last time ...
but doing my 'alter ...' inside and string, launch by exec produce another prob.
execute doesn't seem to be reconized by my Oracle:
I've tested a simple script:
declare
jour varchar2(200);
begin
execute immediate ('select sysdate as Jour from dual');
end;
here is the result :
execute immediate ('select sysdate as Jour from dual');
*
ERREUR à la ligne 2 :
ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "IMMEDIATE" to continue.
...
So what's up 'exec' just exist from 8.i ( aka 8.1+)
Is there a package to download ?
or must i always use 'DBMS_SQL' statement ?
Thank you for your help ...
Gerald
|
|
|
|
|