dbms_job syntax

Still can't get this syntax right.  Anybody know what i'm doing wrong here.

SQL> exec dbms_job.what(188, 'dbms_stats.gather_schema_stats(ownname=>' 'CMS_FILES_ORGS' ',cascade=>TRUE,method_opt=>' 'FOR ALL INDEXEC COLUMNS SIZE AUTO' ');');
BEGIN dbms_job.what(188, 'dbms_stats.gather_schema_stats(ownname=>' 'CMS_FILES_ORGS' ',cascade=>TRUE,method_opt=>' 'FOR ALL INDEXEC COLUMNS SIZE AUTO' ');'); END;

                                                                    *
ERROR at line 1:
ORA-06550: line 1, column 69:
PLS-00103: Encountered the symbol "CMS_FILES_ORGS" when expecting one of the
following:
) , * & | = - + < / > at in is mod remainder not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
xoxomosAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Get rid of the space between the 2 single quotes.  In Oracle they have to be side by side.
0
 
xoxomosAuthor Commented:

SQL> dbms_job.what(188, 'DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>''CMS_FILES_ORGS'',
SP2-0734: unknown command beginning "dbms_job.w..." - rest of line ignored.
SQL>    cascade=>TRUE, method_opt=>''FOR ALL INDEXED COLUMNS SIZE AUTO'');');
SP2-0734: unknown command beginning "cascade=>T..." - rest of line ignored.
SQL>
0
 
xoxomosAuthor Commented:
FINALLY!!!!!!!!!!
Thanx
0
 
slightwv (䄆 Netminder) Commented:
No problem

Looks like you already figured out the SP2-0734.  Just to follow up, if you want to break up the line add a hyphen '-' to the end of the line.  This is the line continuation for SQL*Plus

Note: the space in front of the hypehn is important.
ie./
---------------------------
exec dbms_job.what(188, 'dbms_stats.gather_schema_stats(
ownname=>''CMS_FILES_ORGS'', -
cascade=>TRUE,method_opt=>''FOR ALL INDEXEC COLUMNS SIZE AUTO'');'
);

0
 
xoxomosAuthor Commented:
Thanx again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.