Running sqlplus from ext proc
Hi gurus,
we have an APEX APP that executes some OS scripts using oracle ext proc. We are trying to implement a sqlplus execution in order to import APEX applications. The script is running properly if it's executed from command windows. When we tried to execute it using ext proc the process finished correctly without success. In other cases, if we change the sentence the script is running for hours without success...
We have configured the ext proc and it's working properly as we have others scripts running properly.
create or replace library CAPTURA.EXEC_SHELL as 'C:\windows\system32\msvcrt.dll';