Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

error while executing a script on HpUX

Marco_ALT
Esteemed Contributor

error while executing a script on HpUX

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


any luck with this?
5 REPLIES
Ganesan R
Honored Contributor

Re: error while executing a script on HpUX

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>
Best wishes,

Ganesh.
Marco_ALT
Esteemed Contributor

Re: error while executing a script on HpUX

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
Tim Nelson
Honored Contributor

Re: error while executing a script on HpUX

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

Michal Kapalka (mikap)
Honored Contributor

Re: error while executing a script on HpUX

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
Hein van den Heuvel
Honored Contributor

Re: error while executing a script on HpUX

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.