07-12-2006
SQL Error Message
Hi,
I have a script that will call a .sql file in unix.
My question is, incase the .sql file encountered an error on execution (e.g. 'ORA-00942: table or view does not exist') is it possible to get that error back to the script that call the .sql file?
Please give me an example.
Thanks.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone,
Can anyone explain what the following error refers to...and perhaps a solution?
vxfs: vx_nospace -/tmp file system full (8 block extent)
Thanks,
Uni (2 Replies)
Discussion started by: Uni
2 Replies
2. UNIX for Advanced & Expert Users
I'm getting an error - symbol referencing errors. No output written to, etc
Can anybody tell me why this is? (2 Replies)
Discussion started by: Dan Rooney
2 Replies
3. Solaris
Both of these messages are filling up the /var/adm/messages files on these two Sun boxes, goober and gomer. The print server is called gold.
Jul 31 03:15:40 gold bsd-gw: request to ma28084.Solaris (unknown printer) from goober
Jul 31 03:16:39 gold bsd-gw: request to ma28084.Solaris (unknown... (1 Reply)
Discussion started by: antalexi
1 Replies
4. UNIX for Dummies Questions & Answers
Question for unix programmers - what function I need to used to get the exact error message when the library failed to load?
Thanks (1 Reply)
Discussion started by: tttttt
1 Replies
5. Shell Programming and Scripting
I am new to scripting.
I am using the following script . BART.dat contains the string 'Y' .
#!/bin/ksh
cd /work/TCI/data_out
file=`cat BART.dat`
echo "$file"
if ; then
echo "true"
fi
When i am executing the above script i am getting the following error
./s.ksh: : not found
... (2 Replies)
Discussion started by: ammu
2 Replies
6. UNIX for Dummies Questions & Answers
I keep getting an error message in a script im writing, this line is allways pointed out.
if
and this is the message i keep getting.
line 32: [: 8: unary operator expected
Whats wrong with it?
Please Help. (5 Replies)
Discussion started by: chapmana
5 Replies
7. Linux
Hello
I got this message error on my box with linux red hat
2887a374 WsServer E WSVR0009E: Error occurred during startup
Do you know what does that mean !
Thanks in advance (1 Reply)
Discussion started by: lo-lp-kl
1 Replies
8. UNIX for Dummies Questions & Answers
I was reviewing logs and I got this error message in /var/log/messages:
Did not receive identification string from (IP ADDRESS)
What does it mean? (6 Replies)
Discussion started by: mojoman
6 Replies
9. Shell Programming and Scripting
I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we... (2 Replies)
Discussion started by: pallvi_mahajan
2 Replies
LEARN ABOUT DEBIAN
rt-shredder-4
rt-shredder(8) Request Tracker Reference rt-shredder(8)
NAME
rt-shredder - Script which wipes out tickets from RT DB
SYNOPSIS
rt-shredder --plugin list
rt-shredder --plugin help-Tickets
rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"'
rt-shredder --sqldump unshred.sql --plugin ...
rt-shredder --force --plugin ...
DESCRIPTION
rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT. Script
can be used as example of usage of the shredder API.
USAGE
You can use several options to control which objects script should wipeout.
OPTIONS
--sqldump <filename>
Outputs INSERT queries into file. This dump can be used to restore data after wiping out.
By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql
--object (DEPRECATED)
Option has been deprecated, use plugin "Objects" instead.
--plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]'
You can use plugins to select RT objects with various conditions. See also --plugin list and --plugin help options.
--plugin list
Output list of the available plugins.
--plugin help-<plugin name>
Outputs help for specified plugin.
--force
Script doesn't ask any questions.
SEE ALSO
RT::Shredder
perl v5.14.2 2013-05-22 rt-shredder(8)