ORA-27477
Getting ORA-27477 - when trying to execute a procedure which generates a text file within the database for each given table_name. So, when the job is running and the next job is called - we get an error ORA-27477.
Should I give different job names based on the table_names for which the text file is written? How long is it for the job to auto_drop itself after a successful run?
Please help.