In your SQL, do you have WHENEVER ERROR EXIT .something early on? The syntax allows you to set an exit code for your script to pick up, something like this perhaps:-
It's not tested at all because I no longer have an Oracle database to connect to. I might even have the here document wrong, but you get the idea.
I inherently shy away from putting credentials on the same line as the sqlplus because that would make them visible to a ps command whilst your code is running. There are plenty of examples on the board on how to do it properly.
Hi,
I have a cron job which executes daily once 9 PM.
The script is like
if
then
TYPE=OC
elif
then
TYPE=i
elif
then
TYPE=mmc
elif
then
TYPE=CB
elif
then
TYPE=oth
fi (1 Reply)
Hi all,
I am working on a c source code nearly 2000 line . it contains one big for( i=0; i< 200 ; i++ ) loop of around 600 lines
could any tell me how to break the execution of prog when the value of i is 50 in for loop so that i can check
inside the loop.
Thanks.. (1 Reply)
Hello
i want to incorporate of piece of code in the shell script which checks whether same script is already running or not. If it is already running i want to come out (exit) if its not then continue with the execution of the script.
Any help would be very much appreciated
Thanks (3 Replies)
Hi all,
Is there any command in Unix, which will stop the load process if any error is found in the i/p file?
I am trying to load 5 files sequentially.
A then
B then
C then
D then
E end;
1) If A encounter's any error while data load, the load process should stop, and it should not... (5 Replies)
I have a shell script that writes some data in a file. I want to stop the script after one hour from start of execution using "EXIT 1".
how to do it. I don't want to use CRONTAB. (5 Replies)
Hi,
I run an awk script and I got the error attached below:
here are the lines that the compiler point to as an error:
duration = timeEnd1-timeBegin1;
print "Transmission: type of traffic " flow1 ;
print - Total transmitted bits = totalBits1 bits;
print - duration = ... (2 Replies)
Script:
#!/sbin/sh
echo "Welcome to my First Script"
echo "Enter a word"
read PASS
if then
echo "You are correct"
elif then
echo "Thats incorrect"
else
echo "Bye"
fi
When i run the script shell says:
Syntax error at line 7:'elif' is not expected
I ran through some old posts and... (3 Replies)
hi guys
i have a question
my cron should start executing minute but it sould stop execute only i have tried tis
10 * * * * /home/sample.sh >>
/data/band/cron_$(date+|%Y|m|d).log (2 Replies)
I am writing a bash shell script for GarazLab's "WP EMAIL CRAWLER - AUTO SCRAPER & REAL TIME EXTRACTOR". it contains some commands. I want to stop the shell execution as soon as it encounters an error. how to do it? (8 Replies)
Discussion started by: tahsin352
8 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::procedure
SQL::Translator::Schema::Procedure(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Procedure(3pm)NAME
SQL::Translator::Schema::Procedure - SQL::Translator procedure object
SYNOPSIS
use SQL::Translator::Schema::Procedure;
my $procedure = SQL::Translator::Schema::Procedure->new(
name => 'foo',
sql => 'CREATE PROC foo AS SELECT * FROM bar',
parameters => 'foo,bar',
owner => 'nomar',
comments => 'blah blah blah',
schema => $schema,
);
DESCRIPTION
"SQL::Translator::Schema::Procedure" is a class for dealing with stored procedures (and possibly other pieces of nameable SQL code?).
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Procedure->new;
parameters
Gets and set the parameters of the stored procedure.
$procedure->parameters('id');
$procedure->parameters('id', 'name');
$procedure->parameters( 'id, name' );
$procedure->parameters( [ 'id', 'name' ] );
$procedure->parameters( qw[ id name ] );
my @parameters = $procedure->parameters;
name
Get or set the procedure's name.
$procedure->name('foo');
my $name = $procedure->name;
sql
Get or set the procedure's SQL.
$procedure->sql('select * from foo');
my $sql = $procedure->sql;
order
Get or set the order of the procedure.
$procedure->order( 3 );
my $order = $procedure->order;
owner
Get or set the owner of the procedure.
$procedure->owner('nomar');
my $sql = $procedure->owner;
comments
Get or set the comments on a procedure.
$procedure->comments('foo');
$procedure->comments('bar');
print join( ', ', $procedure->comments ); # prints "foo, bar"
schema
Get or set the procedures's schema object.
$procedure->schema( $schema );
my $schema = $procedure->schema;
equals
Determines if this procedure is the same as another
my $isIdentical = $procedure1->equals( $procedure2 );
AUTHORS
Ken Youens-Clark <kclark@cshl.org>, Paul Harrington <Paul-Harrington@deshaw.com>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Procedure(3pm)