topic Re: error while executing a script on HpUX in Operating System - HP-UX

error while executing a script on HpUX

Marco_ALT — Sun, 09 Aug 2009 09:55:44 GMT

"{Result=An Unknown Error occurred;returnResult=An Unknown Error occurred;STDERR=;returnCode=-1;sessionId=iconclude6959533918153891131;STDOUT=logout
;}"

any luck with this?

Re: error while executing a script on HpUX

Ganesan R — Sun, 09 Aug 2009 10:07:13 GMT

Hi Ibrahim,

what that script actually doing? Was it working earlier? have you modified anything recently?

Have you set required variables and absolute paths inside the script?

Try run in debug mode to find out where it fails.

#sh -x <script name>

Re: error while executing a script on HpUX

Marco_ALT — Sun, 09 Aug 2009 10:11:42 GMT

sure, i was ok before that

actually the flow do the following
- write an SQL script in the file ???.sql.
- An then execute this script with sqlplus
- Collect the return code from sqlplus
- If the return code was not success, then exit with an error
- If the return code was success, then delete the ???.sql script and exit

thanks a lot

Re: error while executing a script on HpUX

Tim Nelson — Sun, 09 Aug 2009 13:07:05 GMT

You might have better luck posting this in a sql forum instead of an hpux forum. The error is specific to sqlplus not hpux.

Re: error while executing a script on HpUX

Michal Kapalka (mikap) — Sun, 09 Aug 2009 14:10:52 GMT

hi,

sqlplus is using by Oracle Admins,

so you should have some information beforu you are going to the DBAs, did you patched te system ??? Wich user should run this script ???

....

mikap

Re: error while executing a script on HpUX

Hein van den Heuvel — Mon, 10 Aug 2009 11:07:36 GMT

Save the generated script.
Inspect.
Try run it 'manually' in SQL*plus.
Observe.

If further help is needed please post the SQL and the exact errors as generated by SQ*plus.
If it is a lot of SQL then include only a summary in the reply, and attach the whole thing as a text file.

This is more likly to be an sQL problem and thus better posted in an Oracle forum, but I suppose there might be a process communication/creation error in the way HPUX is used causing errors to be mishandled.

Hein.