Re: Problem with DBMS_JOB and selecting from dba_data_files

"mkm79" <kostya_at_malishich.com> a écrit dans le message de news: 1135833400.859694.109170_at_g47g2000cwa.googlegroups.com...
| Hi all!
| Oracle9i Enterprise Edition Release 9.2.0.1.0
| I have created a DBMS JOB with code that uses table dba_data_files.
| Checked code in SQL*Plus Worksheet - works good
| But when I trying to RUN JOB with this code it fails with:
| ---
| ORA-12011 ...
| ORA-06512 on "SYS.DBMS_IJOB", line 406
| ORA-06512 on "SYS.DBMS_JOB", line 272
| ORA-06512 at line 1
| ---
| I have write simple code that also isnt works with DBMS_JOB, but in
| SQL*Plus Worksheet it works.
| ---
| declare
| v1 integer;
| begin
| select count(*) into v1 from dba_data_files;
| end;
| ---
| ORA-06512
| Cause: Backtrace message as the stack is unwound by unhandled
| exceptions.
| What is the problem? It is not an insuffisient privileges, right?
| I can post full job SQL, if it help to solve problem.
|
| Thank you for answer
| Malishich
|

Why do you suppress the most important part of what you got?

ORA-6512 is a generic error:
ora-06512: at %sline %s
 *Cause: Backtrace message as the stack is unwound by unhandled

           exceptions.
 *Action: Fix the problem causing the exception or write an exception

           handler for this condition. Or you may need to contact your
           application administrator or DBA.

ora-12011: execution of %s jobs failed
 *Cause: An error was caught in dbms_ijob.run from one or more jobs

          which were due to be run.
 *Action: Look at the alert log for details on which jobs failed and why.

Most likely, you don't have the select privilege on dba_data_files granted *directly*.

Regards
Michel Cadot Received on Thu Dec 29 2005 - 01:05:03 CST