11-23-2010
Thank you very much, it worked but there are empty lines in the log as shown below
2010-11-23 21:27 CST DEBUG: Start executing test1.sql
2010-11-23 21:27 CST
2010-11-23 21:27 CST PL/SQL procedure successfully completed.
2010-11-23 21:27 CST
2010-11-23 21:27 CST DEBUG: Completed executing test1.sql
2010-11-23 21:27 CST DEBUG: Start executing SQL loader
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am using a query like below in my shell script :
{
{
echo "set echo off"
echo "set head off"
echo "whenever sqlerror exit -1;
select NUMBER ||','||
FNAME ||','||
LOC ||','||
... (2 Replies)
Discussion started by: deepakgang
2 Replies
2. Shell Programming and Scripting
HELLO,
I am using such a command to write oracle sqlplus query result to text file:
sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt
Is it possible to script that:
If command succesfull write in \tmp\log.txt:
timestamp and "succeded"
and create 123.txt with results
else
If error... (2 Replies)
Discussion started by: tomasba
2 Replies
3. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
4. Shell Programming and Scripting
UNIX Gods,
I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions?
Thanks in advance.
#!/bin/ksh
export USAGE="USAGE: `basename $0` -e <DBUSER> <DBPASSWD> <TNSNAME>"
if ; then
... (2 Replies)
Discussion started by: WhoDatWhoDer
2 Replies
5. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
6. Shell Programming and Scripting
Hi Guys,
I am using set -x in my script to track the flow of the script.
But if i want to write the output of the set -x into a log file, how do i do it?
Thanks,
Ajay (3 Replies)
Discussion started by: Ajay Venkatesan
3 Replies
7. Shell Programming and Scripting
Hi,
facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there.
ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Discussion started by: rushikeshs
2 Replies
8. Shell Programming and Scripting
Hi
I am trying to write output to a file in columns
I have file in the follwoing:
# cat file
abc
def
#
I am trying to write next output as like
# cat file
abc 123
def 345
#
:mad: (6 Replies)
Discussion started by: Priya Amaresh
6 Replies
9. Shell Programming and Scripting
HI
I am trying to grep 3 characters from hostname and append a character at the end.
I tried as in the following:
root@abag3:~# hostname | cut -c1-3
hyu
Now I am trying to append "g" at the end of this output as in the following.
root@abag3:~# hostname | cut -c1-3 | sed -s... (4 Replies)
Discussion started by: Priya Amaresh
4 Replies
10. Shell Programming and Scripting
Hello,
I am having problem while redirecting output to a file where as on console output is proper.
for dir in */; do printf "%s, " "$dir"; ls -m "$dir"; echo; done > output.txt
Output of above command is coming in single line but when i am redirecting output to a file, single line i... (10 Replies)
Discussion started by: Manoj Rajput
10 Replies
LEARN ABOUT DEBIAN
data::phrasebook::sql::query
Data::Phrasebook::SQL::Query(3pm) User Contributed Perl Documentation Data::Phrasebook::SQL::Query(3pm)
NAME
Data::Phrasebook::SQL::Query - Query Extension to the SQL/DBI Phrasebook Model.
SYNOPSIS
my $q = $book->query( 'find_author' );
my $q = $book->query( 'find_author', 'Dictionary' );
DESCRIPTION
An extension to the SQL class to specifically handle the DBI interface for each query requested.
CONSTRUCTOR
new
Not to be accessed directly, but via the parent Data::Phrasebook, by specifying the class as SQL.
METHODS
sql
Get/set the current "sql" statement, in a form suitable for passing straight to DBI.
sth
Get/set the current statement handle.
args
Return list of arguments that will be used as bind parameters to any placeholders. Any given arguments will replace the whole list.
Returns list in list context, arrayref in scalar.
order
As for "args", but regarding the corresponding list of argument names.
The assorted "order_XXX" methods are supported as for "args_XXX".
dbh
Get/set the database handle.
PREPARATION
/ EXECUTING METHODS
execute
Executes the query. Returns the result of "DBI::execute".
Any arguments are given to "order_args" with the return of that method being used as arguments to "DBI::execute". If no arguments, uses
those already specified.
Calls "prepare" if necessary.
order_args
Given a hash or hashref of keyword to value mappings, organises an array of arguments suitable for use as bind parameters in the order
needed by the query itself.
prepare
Prepares the query for execution. This method is called implicitly in most cases so you generally don't need to know about it.
rebind
Rebinds any bound values. Lets one pass a scalar reference in the arguments to "order_args" and have the bound value update if the original
scalar changes.
This method is not needed externally to this class.
DELEGATED METHODS
Any method not mentioned above is given to the statement handle.
All these delegations will implicitly call "prepare".
SEE ALSO
Data::Phrasebook, Data::Phrasebook::SQL.
SUPPORT
Please see the README file.
AUTHOR
Original author: Iain Campbell Truskett (16.07.1979 - 29.12.2003)
Maintainer: Barbie <barbie@cpan.org> since January 2004.
for Miss Barbell Productions <http://www.missbarbell.co.uk>.
COPYRIGHT AND LICENSE
Copyright (C) 2003 Iain Truskett.
Copyright (C) 2004-2010 Barbie for Miss Barbell Productions.
This module is free software; you can redistribute it and/or
modify it under the Artistic Licence v2.
perl v5.10.1 2010-08-31 Data::Phrasebook::SQL::Query(3pm)