Re: PL/SQL calling Procedures from others

On Tue, 4 Sep 2001, t.ruschival_at_vivid-md.de wrote:

> SQL> EXEC DBMS_JOB.SUBMIT(1, fp_dba.monatsbericht, SYSDATE,
> SQL> SYSDATE+1)
> 
> It doesn´t submit this Job, it throws an PLS-0222 error:

From the example in the doc,
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/jobq.htm#7997 ,----
| As an example, let's submit a new job to the job queue. The job
| calls the procedure DBMS_DDL.ANALYZE_OBJECT to generate optimizer
| statistics for the table DQUON.ACCOUNTS. The statistics are based
| on a sample of half the rows of the ACCOUNTS table. The job is
| run every 24 hours.
|
| VARIABLE jobno number;
| BEGIN
| DBMS_JOB.SUBMIT(:jobno,
| 'dbms_ddl.analyze_object(''TABLE'',
| ''DQUON'', ''ACCOUNTS'',
| ''ESTIMATE'', NULL, 50);',
| SYSDATE, 'SYSDATE + 1');
| COMMIT;
| END;
| /
| Statement processed.
| PRINT jobno
| JOBNO
| ----------
| 14144

`----

Try:
EXEC DBMS_JOB.SUBMIT(1, 'fp_dba.monatsbericht', 'SYSDATE', 'SYSDATE+1');

-- 
Galen Boyer
It seems to me, I remember every single thing I know.