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)
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)
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)
Hi,
Can anyone please let me know where to check if a particular stored procedure exists.
If the procedure exists I want to display some message and if the procedure does not exists i want to exit with error message.
checking from dba_objects doesnt help. suprisingly the procedure i... (3 Replies)
Hi,
My stored procedure returns a value.
How to retrieve the value and display in unix.
Stored procedure
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;
Unix Scripting i used
sqlplus -s... (7 Replies)
Hi,
I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server.
If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix... (2 Replies)
Discussion started by: Rahul Raj
2 Replies
LEARN ABOUT DEBIAN
net::google::code::atomparser
Net::Google::Code::AtomParser(3pm) User Contributed Perl Documentation Net::Google::Code::AtomParser(3pm)NAME
Net::Google::Code::AtomParser - AtomParser with a parsing method for gcode
DESCRIPTION INTERFACE
new
parse( $xml_content )
return( $feed, $entries ), $feed is a hashref like {
'title' => 'Issue updates for project net-google-code on Google Code',
'id' => 'http://code.google.com/feeds/p/net-google-code/issueupdates/basic',
'updated' => '2009-06-12T05:55:48Z' }
$entries is an arrayref like [
{
'content' => '<pre>second comment
</pre>
',
'name' => 'sunnavy',
'title' => 'Update 2 to issue 22 ("for sd test")',
'id' => 'http://code.google.com/feeds/p/net-google-code/issueupdates/basic/22/2',
'updated' => '2009-06-12T05:55:48Z'
},
{
'content' => '<pre>first comment
</pre>
',
'name' => 'sunnavy',
'title' => 'Update 1 to issue 22 ("for sd test")',
'id' => 'http://code.google.com/feeds/p/net-google-code/issueupdates/basic/22/1',
'updated' => '2009-06-12T05:55:22Z'
}, ]
AUTHOR
sunnavy "<sunnavy@bestpractical.com>"
LICENCE AND COPYRIGHT
Copyright 2008-2010 Best Practical Solutions.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-01-29 Net::Google::Code::AtomParser(3pm)