01-27-2011
Last edited by k_manimuthu; 01-27-2011 at 05:22 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script.
I have tried the following, (no input params):
/usr/bin/mysql -uadmin -ppassword call TL_CLENSEDATA();
resulting in error:
/home/hosting/data/scripts/dbclense.sh: line 12: syntax error... (3 Replies)
Discussion started by: kshelluser
3 Replies
2. Shell Programming and Scripting
Hi Guys,
I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script.
When i use the following in my script,
db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE
I am getting an error..
Please... (1 Reply)
Discussion started by: mac4rfree
1 Replies
3. Shell Programming and Scripting
Hi GUYS,
I need to trigger 3 stored procedure at the same time..
I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful..
Thanks for your help in advance,
Magesh (1 Reply)
Discussion started by: mac4rfree
1 Replies
4. Programming
Hi ,
I have a dellimited .dat file and a sqlloader.
I want to call the sqlloader from a oracle stored procedure.
The procedure should return the result of sqlloader's execution. (3 Replies)
Discussion started by: Haque123
3 Replies
5. Shell Programming and Scripting
Hi!
I got an strange trouble executing a stored procedures that goes inserting line by line on a table. I mus integrate it with perl for an specific task... the hole process is controlled by e Perl script that:
Load a text file calling sqlldr.
Call a stored procedure that process the... (2 Replies)
Discussion started by: jparra
2 Replies
6. Shell Programming and Scripting
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
Discussion started by: barani75
6 Replies
7. Shell Programming and Scripting
Hi,
Can you assist me in how to redirect the output of oracle stored procedure from unix script?
Something similar to what i did for sybase
isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %%
proc_my_test 8
go
%%
Thanks in advance - jak (0 Replies)
Discussion started by: jakSun8
0 Replies
8. Shell Programming and Scripting
How to call a stored procedure from shell program (1 Reply)
Discussion started by: noorm
1 Replies
9. Shell Programming and Scripting
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies
10. Shell Programming and Scripting
How to call a stored procedure inside a loop
export PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=xxxx; export ORACLE_SID ORAENV_ASK=NO
TODAY_DATE=$(date +"%Y%m%d")
LOGFILE=/var/opt/gogd/cust/scripts/${TODAY_DATE}_sap_cust_rel.log
echo 'Connected'
PARCUST=sap_cust_rel.par
sqlldr... (1 Reply)
Discussion started by: ashwanth
1 Replies
LEARN ABOUT DEBIAN
io::all::http
IO::All::HTTP(3pm) User Contributed Perl Documentation IO::All::HTTP(3pm)
NAME
IO::All::LWP - Extends IO::All to HTTP URLs
SYNOPSIS
use IO::All;
$content < io('http://example.org'); # GET webpage into scalar
io('http://example.org') > io('index.html'); # GET to file
"hello
" > io('http://example.org/index.html'); # PUT webpage
# two ways of getting a page with a password:
$content < io('http://me:secret@example.org');
$content < io('http://example.org')->user('me')->password('secret');
DESCRIPTION
This module extends IO::All for dealing with HTTP URLs. Note that you don't need to use it explicitly, as it is autoloaded by IO::All
whenever it sees something that looks like an HTTP URL.
The SYNOPSIS shows some simple typical examples, but there are many other interesting combinations with other IO::All features! For
example, you can get an HTTP URL and write the content to a socket, or to an FTP URL, of to a DBM file.
METHODS
This is a subclass of IO::All::LWP. The only new method is "http", which can be used to create a blank IO::All::HTTP object; or it can also
take an HTTP URL as a parameter. Note that in most cases it is simpler just to call io('http://example.com'), which calls the "http" method
automatically.
OPERATOR OVERLOADING
The same operators from IO::All may be used. < GETs an HTTP URL; > PUTs to an HTTP URL.
SEE ALSO
IO::All, IO::All::LWP, LWP.
AUTHORS
Ivan Tubert-Brohman <itub@cpan.org> and Brian Ingerson <ingy@cpan.org>
COPYRIGHT
Copyright (c) 2007. Ivan Tubert-Brohman and Brian Ingerson. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
perl v5.10.0 2007-03-29 IO::All::HTTP(3pm)