var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DBMS_JOB Issue
Can you help me to resolve the below error.
I was trying to create a job with below script and ended up the an error.
job => X
,what => 'truncate table daily_snapshot_tmp;
insert into daily_snapshot_tmp
SELECT DISTINCT TRUNC(SYSDATE - 1) AS snapshot_date,
nvl(max(******) as ABC
nvl(max(******) as XYZ
cast(null as number(10,2)) as ASDF
cast(null as number(10,2)) as ZXCV
update daily_snapshot_tmp arm set
ZXV = <condition>
next_date => to_date('18/06/2012 13:00:05','dd/mm/yyyy hh24:mi:ss')
,no_parse => FALSE
:JobNumber := to_char(X);
ORA-06550: line 1, column 102:
PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:
:= . ( @ % ;
The symbol ":= was inserted before "TABLE" to continue.
ORA-06550: line 10, column 26:
PLS-00103: Encountered the symbol "(" when expecting one of the following:
. ) @ %
The symbol ")" was substituted for "(" to continue.
ORA-06550: line 10, column 32:
PLS-00103: Encountered the symbol ")" when expecting one of the following:
. ( , * % & - + / at mod rem <an identifier>
You're missing a single quote at the end
what => 'truncate table daily_snapshot_tmp
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.