I CAN SUBMIT A JOB BUT AS SONN AS IT EXECUTES IT GOES IN THE EXEPTIONS OF MY PROCEDURE. I HAVE TRAPED ERROR NO 2394 WICH MAKES NO SENSE TO ME CAUSE MY USER HAS UNLIMITED EVERYTHING. IF I DO A DBMS_JOB.RUN IT WORKS FINE. THIS PACKAGE WAS DEVELOPED ON 8I AND WORKS PERFECT THERE,IT'S ON 8.0.5.0 THAT THE BUGS ARE. ANY THOUGHTS? THANKS.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DBMS_JOB
- Thread starter SZABO
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
What type of 'UNLIMITED EVERYTHING' do you mean it might not refer to LOGICAL_READS_PER_SESSION.<br><br>Regards<br><br>Kevin
- Thread starter
- #3
This is on a dba account and every place that can have a limite is marked unlimited (cpu,logical reads, sessions ...) I have tried the same package and commands on an other database and everything is fine so I think the database has trouble (and that is not my job). Thank you for your time, szabo.
- Status
Similar threads
- Locked
- Question