07-07-2011
Hi,
Thanks a lot....can u kindly explain the code also.....bcoz wats the difference between sqlplus and sqlplus -s......
Thanks,
kriti
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
8 Replies
2. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
3. Shell Programming and Scripting
Hi, I have problems with running shell script connecting to Oracle from the crontab. Here is the script:
#!/sbin/sh
ORACLE_HOME=/opt/oracle/10g/
export ORACLE_HOME
if
then
echo "Source path is not specified"
exit
fi
/opt/oracle/10g/bin/sqlplus user/pass@testdb << EOF
truncate table... (6 Replies)
Discussion started by: apenkov
6 Replies
4. Shell Programming and Scripting
Hi,
I want to connect to oracle db using unix shell script. And i want to retrieve data from db through shell script.
Please help me as soon as possible.
Thanks,
J.P. Das (1 Reply)
Discussion started by: jyotidas
1 Replies
5. Shell Programming and Scripting
Please help me in writing a shell script which connects to a Oracle instance and tables to get the required information...:wall: (1 Reply)
Discussion started by: Dpu
1 Replies
6. Shell Programming and Scripting
Hi Unix Gurus,
I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any... (8 Replies)
Discussion started by: bshivali
8 Replies
7. Shell Programming and Scripting
Hi All,
I am newbie to unix shell scripting. I want to connect to oracle database using shell script. I know how to connect DB using user name and password but my question is if my password is having '@' sign then how to connect.
I have tried like below,
cnt=`sqlplus -s /nolog << EOFSQL
... (3 Replies)
Discussion started by: pmotewar
3 Replies
8. Shell Programming and Scripting
Hi Master,
I need to create dan run script in linux to get data from teradata
I did this
---------- Post updated at 02:28 AM ---------- Previous update was at 02:25 AM ----------
LOG_DIR="/home/";
OUTDIR="/home/";
SCRIPT_NAME=“test";
DUMPFILE="${OUTDIR}${SCRIPT_NAME}"_"$(date... (2 Replies)
Discussion started by: radius
2 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
Would like to write a Script which will run between 11am to 3 pm and send the results to output.txt.
Please suggest. (2 Replies)
Discussion started by: vasuvv
2 Replies
10. Shell Programming and Scripting
Hi,
I am facing an issue in connecting to database from Linux shell script. Here is my code
export ORACLE_BASE=xxx
export ORACLE_SID=xxx
export ORACLE_HOME=xxxx
DB_PATH=xxx/'yyy@yy'
UserId=`sqlplus -s $DB_PATH <<EOF
set head off feedback off
select max(USER_ID)+1 from USERS;... (6 Replies)
Discussion started by: yuvi
6 Replies
LEARN ABOUT DEBIAN
sru::server
SRU::Server(3pm) User Contributed Perl Documentation SRU::Server(3pm)
NAME
SRU::Server - respond to SRU requests via CGI::Application
SYNOPSIS
package MySRU;
use base qw( SRU::Server );
sub explain {
my $self = shift;
# $self->request isa SRU::Request::Explain
# $self->response isa SRU::Response::Explain
}
sub scan {
my $self = shift;
# $self->request isa SRU::Request::Scan
# $self->response isa SRU::Response::Scan
# $self->cql is the root node of a CQL::Parser-parsed query
}
sub searchRetrieve {
my $self = shift;
# $self->request isa SRU::Request::SearchRetrieve
# $self->response isa SRU::Response::SearchRetrieve
# $self->cql is the root node of a CQL::Parser-parsed query
}
package main;
MySRU->new->run;
DESCRIPTION
This module brings together all of the SRU verbs (explain, scan and searchRetrieve) under a sub-classable object based on CGI::Application.
METHODS
explain
This method is used to return an explain response. It is the default method.
scan
This method returns a scan response.
searchRetrieve
This method returns a searchRetrieve response.
CGI
::APPLICATION METHODS
setup
Sets the "run_modes", "mode_param" and the default runmode (explain).
cgiapp_prerun
Parses the incoming SRU request and if needed, checks the CQL query.
cgiapp_postrun
Sets the content type (text/xml) and serializes the response.
error_mode
Stub error runmode.
AUTHORS
o Brian Cassidy <bricas@cpan.org>
o Ed Summers <ehs@pobox.com>
perl v5.12.4 2009-11-20 SRU::Server(3pm)