dbms_jobs failed with ORA-06550 [message #302145] |
Sun, 24 February 2008 02:50  |
caprikar
Messages: 226 Registered: March 2007
|
Senior Member |
|
|
Hi,
I'm trying to schedule a job with the following:
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => X
,what => 'PREP.CREATE_SPL_BED;'
,next_date => to_date('02/25/2008 01:00:00','mm/dd/yyyy hh24:mi:ss')
,no_parse => FALSE
);
:JobNumber := to_char(X);
END;
and it failed with:
DECLARE
*
ERROR at line 1:
ORA-06550: line 1, column 98:
PLS-00302: component 'CREATE_SPLBED' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 4
|
|
|
|
|
|
Re: dbms_jobs failed with ORA-06550 [message #302245 is a reply to message #302145] |
Mon, 25 February 2008 00:55   |
caprikar
Messages: 226 Registered: March 2007
|
Senior Member |
|
|
Hi,
That was typo, it was
DECLARE
*
ERROR at line 1:
ORA-06550: line 1, column 98:
PLS-00302: component 'CREATE_SPL_BED' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 4
|
|
|
Re: dbms_jobs failed with ORA-06550 [message #302247 is a reply to message #302206] |
Mon, 25 February 2008 00:59   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
caprikar wrote on Mon, 25 February 2008 04:56 | Hi,
I did grant exectute on that procedure to sys and tried to schedule the job but sill getting the same error.
|
There really is no need to grant anything to sys, as
- sys already has grants on anything
- you should never ever use sys.
Typo??
Do you mean you retyped the complete error-message? Why did you not copy-paste it?
[Updated on: Mon, 25 February 2008 01:00] Report message to a moderator
|
|
|
|
|
|
|
Re: dbms_jobs failed with ORA-06550 [message #302504 is a reply to message #302438] |
Mon, 25 February 2008 23:51   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Littlefoot wrote on Mon, 25 February 2008 19:06 | Well, yes, you are right (sort of), but my words are more ... poetic, so - if OP's sensitive heart feels these gentle vibrations, perhaps he'll melt like icecream on a hot tin roof and better understand what we meant.
|
So true, so true. Sorry for my rude intervention of this masterpiece in poetry. I was but too blind to see the majestic pattersn, too deaf to hear those gorgeous tones, too unworthy to recognize the sheer class of it all...
(bow) (bow) (bow)
**crawling back under rock
|
|
|
|