10-28-2002
Return status...
Hello there!
Here is my problem. I hope I can get some help about it.
I need to know how can I get the return code of an application in the Unix shell script.
The script is like below:
PREVIOUS STATEMENT & VARIABLES
sqlplus scott/tiger @$sqldir/$sqlscript
NEXT STATEMENT (Like status=$?)
If for some reason sqlplus (Oracle client application for making a connection to Oracle or run a PL/SQL script against Oracle)
craps out, script will stop running, but, It does not return to the next statement after sqlplus... I've already tried "$?" to capture the return code but as I said the next statement after sqlplus never be reached....
I run the script using nohup on a AIX machine.
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I still have problems when trying to figure out if the status of an ftp was successful. I ftp to different types (nt, vax, unix, etc...) of machines. I am trying to write a universal script that will ftp a file and then check to see if the ftp was successful. I have tried the... (12 Replies)
Discussion started by: blt123
12 Replies
2. Shell Programming and Scripting
hi, I set the crontab to execute script A every 5 minutes from 9:00 am to 4:00 pm everyday, now at 12:00am I want to run another script if and only if all the previous runs of script A return OK, can anyone tell me how it could be done? thank you very very much! (4 Replies)
Discussion started by: mpang_
4 Replies
3. Shell Programming and Scripting
Hi all
below is a snippet of my perl codesystem ("scp -pq $dest_file $path");How i can i trap the return status? ie if the scp fails how can i know ? (2 Replies)
Discussion started by: new2ss
2 Replies
4. HP-UX
I have the question:
How return the exit code from then assign :
VAR=$(command ) for ex. VAR=$(ls ....)
VAREXIT=$?
echo $VAREXIT
VAREXIT is equal to 0 if the directory exist or not exist. WHI??
if i execute the command direct from line-command , the value of $? is different if... (1 Reply)
Discussion started by: ZINGARO
1 Replies
5. Shell Programming and Scripting
Hi all
I'm trying to evalute the return status of a function without much success. I've put a very basic example below to explain.
check_ok() works fine but when used within an if statement, it always returns true, whether it is true or false. I'm guessing it returns true as the function... (4 Replies)
Discussion started by: tig2810
4 Replies
6. Shell Programming and Scripting
Hello,
I have a C++ binary that runs in my perl script. But, Currently, the binary is doing a core dump and i want to capture the retrun status of the binary to report as an issue.
Can you please help me on this.
Thanks,
Sateesh (1 Reply)
Discussion started by: kotasateesh
1 Replies
7. Shell Programming and Scripting
Hello,
I have a C++ binary that runs in my perl script. But, Currently, the binary is doing a core dump and i want to capture the retrun status of the binary to report as an issue.
Can you please help me on this.
Thanks,
Sateesh (1 Reply)
Discussion started by: kotasateesh
1 Replies
8. Shell Programming and Scripting
i have to run set of commands
command1
command2
command3
command4
Now Whenever any of these command fails i should quit while capturing error message.
Is there a better way then checking for $? after each command. (1 Reply)
Discussion started by: vickylife
1 Replies
9. UNIX for Dummies Questions & Answers
there is something wrong with my system. when I do this:
diff file1 file1 && echo 1
the output is 1.
but
diff file1 file2 >/dev/null && echo 1
output nothing
while
diff file1 file2 >/dev/null || echo 1
shows 1.
the same with "grep" return status. they are both GNU utilities.... (5 Replies)
Discussion started by: phil518
5 Replies
10. Shell Programming and Scripting
Hi can you explain me, what does variables $@ and $* return and how are they used, if can give me a sample example it could be helpful.
Thanks in advance,
Regards,
Abhishek S. (1 Reply)
Discussion started by: abhisheksunkari
1 Replies
LEARN ABOUT PHP
oci_error
OCI_ERROR(3) OCI_ERROR(3)
oci_error - Returns the last error found
SYNOPSIS
array oci_error ([resource $resource])
DESCRIPTION
Returns the last error found.
The function should be called immediately after an error occurs. Errors are cleared by a successful statement.
PARAMETERS
o $resource
- For most errors, $resource is the resource handle that was passed to the failing function call. For connection errors with
oci_connect(3), oci_new_connect(3) or oci_pconnect(3) do not pass $resource.
RETURN VALUES
If no error is found, oci_error(3) returns FALSE. Otherwise, oci_error(3) returns the error information as an associative array.
oci_error(3) Array Description
+----------+--------------------------------------+---+
|Array key | | |
| | | |
| | Type | |
| | | |
| | Description | |
| | | |
+----------+--------------------------------------+---+
| | | |
| code | | |
| | | |
| | | |
| | integer | |
| | | |
| | The Oracle error number. | |
| | | |
| | | |
| message | | |
| | | |
| | | |
| | string | |
| | | |
| | The Oracle error text. | |
| | | |
| | | |
| offset | | |
| | | |
| | | |
| | integer | |
| | | |
| | The byte position of an error in | |
| | the SQL statement. If there was no | |
| | statement, this is 0 | |
| | | |
| | | |
| sqltext | | |
| | | |
| | | |
| | string | |
| | | |
| | The SQL statement text. If there | |
| | was no statement, this is an empty | |
| | string. | |
| | | |
+----------+--------------------------------------+---+
EXAMPLES
Example #1
Displaying the Oracle error message after a connection error
<?php
$conn = oci_connect("hr", "welcome", "localhost/XE");
if (!$conn) {
$e = oci_error(); // For oci_connect errors do not pass a handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #2
Displaying the Oracle error message after a parsing error
<?php
$stid = oci_parse($conn, "select ' from dual"); // note mismatched quote
if (!$stid) {
$e = oci_error($conn); // For oci_parse errors pass the connection handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #3
Displaying the Oracle error message, the problematic statement, and the position of the problem of an execution error
<?php
$stid = oci_parse($conn, "select does_not_exist from dual");
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid); // For oci_execute errors pass the statement handle
print htmlentities($e['message']);
print "
<pre>
";
print htmlentities($e['sqltext']);
printf("
%".($e['offset']+1)."s", "^");
print "
</pre>
";
}
?>
PHP Documentation Group OCI_ERROR(3)