Hi.
We are using database 19c SE.
We created script that exports APEX application page into CLOB. Now we want to import thats script inside plsql. We managed to do it by creating scheduler job using dbms_scheduler. Running as job_type SQL_SCRIPT. Job_action as 'job_action => 'begin '|| p_export_script||' end;'
It works if the export is small. When we try to import export that is big (lots of lines), job creation returns error: ORA-06502: PL/SQL: numeric or value error.
Is there any other way to use and run script that is in clob - from scheduler? Or some other way to run import script inside plsql?
Thanks.
BR