PL/SQL (MOSC)

MOSC Banner

Running sqlplus from ext proc

edited Jun 23, 2018 5:00AM in PL/SQL (MOSC) 1 commentAnswered

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';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center