Sponsored Content
Full Discussion: SQL Error Message
Top Forums Shell Programming and Scripting SQL Error Message Post 302079647 by kakashi_jet on Wednesday 12th of July 2006 05:07:53 AM
Old 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

Error Message

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

Error message

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

lp error message

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

getting last error message

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

Error message

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

Error Message

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

error message

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

What does this error message mean?

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

How to get rid off Password expiry error message when connecting to sql in script?

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
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)
All times are GMT -4. The time now is 07:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy