Hi guys,
I work on Oracle 9i on Sun OS.
The problem I'm encountering right now is an 'ORA-21000: error number argument to raise_application_error of -1 out of range' with an 'ORA-06512: at "<Application-Package Name>", line <so-and-so>.
To be more clear, the application works perfectly fine from the back-end (meaning the OS prompt), but the application failure happens when the particular process is run from the front-end (through IE). The front-end is a normal PL/SQL procedure which is web-enabled through HTP packages embedded within.
I've tried backtracing the application till the start of the process, I fear I havent been able to find the root cause. However, one thing I would like to elaborate is about what the application finally does. All it does is FTPing certain application-generated files to another Unix machine. Also to be more specific, this has been running perfectly for years together till it failed quite recently. To re-explain, the entire procedure works fine from the OS prompt, it fails from the front-end alone. Could anyone out here help me out? I hope the information I've given would be enough. If there is any more information required for helping me better, please do ask me.
With Best Regards,
Anand Seetharaman