11-26-2001
Hello
When i try to excute the script i get the following
sqlplus -s scott/tiger
XX EOF |grep [O]RA | uniq|cut -f1 -d : select Mail creF
my oracle database is up and running .i connect as scott tiger
it is obvious here to me that i am unanle to capture the error code into variable x am i right ?
regards
Hrishy
Last edited by xiamin; 11-26-2001 at 01:03 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I'm hoping I could get some help on the following. I'm writing a script which will in turn create an ftp script then excecute it. eg
echo "user $user $pass" > $script
echo "cd $remote_dir" >> $script
echo "bi" >> $script
echo "mput $file" >> $script
echo "bye" >> $script
ftp -n -i $ip... (1 Reply)
Discussion started by: Bab00shka
1 Replies
2. UNIX for Dummies Questions & Answers
I have written a UNIX script that will automatically ftp a file to a server. The problem is when I missed enter information w/in the .txt file that contains the userid/password and what file to transfer, I had no way of capturing the failuer of the file transfer. I verified w/in the script that the... (1 Reply)
Discussion started by: dhawkjrscripter
1 Replies
3. Shell Programming and Scripting
Hi,
Can anybody tell me how to error trap an empty line. If i am asked for a password and I hit enter without entering any text, how do i display an error?
Thanks
Kev (6 Replies)
Discussion started by: kev112
6 Replies
4. Shell Programming and Scripting
I am writing a program which is something like below:
rsh host1 "rcp file dest:directory"
I am running this script from a machine host2.
host1 has rlogin configuration for host2.
but, dest machine has no rlogin configuration for host1 and fails on remote calls.
Could anyone tell me how... (2 Replies)
Discussion started by: vvejendla
2 Replies
5. Shell Programming and Scripting
How can I trap and print "cannot find the pattern" when the grep is unable to find the specified pattern in the file using the for loop below ?
Any help would be appreciated.
bash3.4> cat test_file
apple
orange
pineapple
blackberry
script:
for x in `grep -n "mango" test_file... (4 Replies)
Discussion started by: jville
4 Replies
6. Shell Programming and Scripting
I hope that I can trap curl errors, and have my shell script error out and quit if curl has any sort of problem.
For example, I have the following command in my shell script:
curl --trace -n -v --ftp-ssl ftp://xxx.xxx.xxx.xxx:2122 --user user:password -o /tmp/file.txt
Works great, except... (2 Replies)
Discussion started by: prestonatwork
2 Replies
7. Shell Programming and Scripting
Hello
I have a program (prog) that accepts a parameter in order to execute some internal loop grabbing memory in each iteration. I'm using top to monitor the memory usage and to produce an output.
Thus I need the program's pid as a parameter to top.
I capture pid using myPID=$!.
I'm also... (5 Replies)
Discussion started by: pavlosgr
5 Replies
8. UNIX for Advanced & Expert Users
Dear all,
How to make sqlplus command to exit with an apt error code in bash script,
It always returns 0 for me.
Thanks (9 Replies)
Discussion started by: vetrivendhan
9 Replies
9. Shell Programming and Scripting
Hi,
I have one shell script as below
while read SegList
do
if test -s ${SourceFile_Path}/${Segment_List_Temp}
then
ls -r -1 ${FTP_Path}/${SegList}.DAT.${Datelist}.GZ|cut -d '.' -f2>>${SourceFile_Path}/${List_Temp}
echo "IF above statment Fail I want to Create Emtpy File How to Trapp... (3 Replies)
Discussion started by: samadhanpatil
3 Replies
10. Shell Programming and Scripting
I have a requirement:
During copy command for example:
cp -rf <sourceDir> <destinationDir>
this command may fails for many reasons like:
1. source or destination directory does not exist
2. destination directory does not have sufficient space
3. directories are not mounted
... Or may... (3 Replies)
Discussion started by: ambarginni
3 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::oracle
SQL::Translator::Producer::Oracle(3pm) User Contributed Perl Documentation SQL::Translator::Producer::Oracle(3pm)
NAME
SQL::Translator::Producer::Oracle - Oracle SQL producer
SYNOPSIS
use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'Oracle' );
print $translator->translate( $file );
DESCRIPTION
Creates an SQL DDL suitable for Oracle.
producer_args
delay_constraints
This option remove the primary key and other key constraints from the CREATE TABLE statement and adds ALTER TABLEs at the end with it.
quote_field_names
Controls whether quotes are being used around column names in generated DDL.
quote_table_names
Controls whether quotes are being used around table, sequence and trigger names in generated DDL.
NOTES
Autoincremental primary keys
This producer uses sequences and triggers to autoincrement primary key columns, if necessary. SQLPlus and DBI expect a slightly different
syntax of CREATE TRIGGER statement. You might have noticed that this producer returns a scalar containing all statements concatenated by
newlines or an array of single statements depending on the context (scalar, array) it has been called in.
SQLPlus expects following trigger syntax:
CREATE OR REPLACE TRIGGER ai_person_id
BEFORE INSERT ON person
FOR EACH ROW WHEN (
new.id IS NULL OR new.id = 0
)
BEGIN
SELECT sq_person_id.nextval
INTO :new.id
FROM dual;
END;
/
Whereas if you want to create the same trigger using "do" in DBI, you need to omit the last slash:
my $dbh = DBI->connect('dbi:Oracle:mysid', 'scott', 'tiger');
$dbh->do("
CREATE OR REPLACE TRIGGER ai_person_id
BEFORE INSERT ON person
FOR EACH ROW WHEN (
new.id IS NULL OR new.id = 0
)
BEGIN
SELECT sq_person_id.nextval
INTO :new.id
FROM dual;
END;
");
If you call this producer in array context, we expect you want to process the returned array of statements using DBI like "deploy" in
DBIx::Class::Schema does.
To get this working we removed the slash in those statements in version 0.09002 of SQL::Translator when called in array context. In scalar
context the slash will be still there to ensure compatibility with SQLPlus.
CREDITS
Mad props to Tim Bunce for much of the logic stolen from his "mysql2ora" script.
AUTHORS
Ken Youens-Clark <kclark@cpan.org>, Alexander Hartmaier <abraxxa@cpan.org>, Fabien Wernli <faxmodem@cpan.org>.
SEE ALSO
SQL::Translator, DDL::Oracle, mysql2ora.
perl v5.14.2 2012-01-18 SQL::Translator::Producer::Oracle(3pm)