04-17-2010
How to execute the stored procedure from shell script
How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
This is a very starnge problem I am having. I have a shell script that calls a stored procedure.
Here's my code in shell script:
sqlplus "userid/pwd" @file.sql
and file.sql has the following statement:
exec my_storedProc;
Now, when I execute my shell script, nothing... (2 Replies)
Discussion started by: priyamurthy2005
2 Replies
2. Shell Programming and Scripting
Here is a snippet of my code:
if
then
echo "\n Deleting all reports older than 24 hours. \n" >> $logfile
ls -l $FileName >> $logfile
... (1 Reply)
Discussion started by: mh53j_fe
1 Replies
3. Shell Programming and Scripting
HI,
I have a similar problem to thread 18264, only I couldn't get it to work.
https://www.unix.com/showthread.php?t=18264
I have a stored procedure which is called by a shell script program. When I run the stored procedure alone or through the shell script, it works fine with output text... (3 Replies)
Discussion started by: dorisw
3 Replies
4. Shell Programming and Scripting
hi all
please tell me how to pass parameters 4m shell script to a DataBase stored procedure.
To be specific i have sybase DB.
i mean i want the syntax of the command..
how to connect to DB, pass user id and password, pass the required parameter to SP..
..
need ur help frnds..
hema (0 Replies)
Discussion started by: hema2026
0 Replies
5. Shell Programming and Scripting
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Discussion started by: shirdi
1 Replies
6. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
7. 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
8. Shell Programming and Scripting
I am invoking a SQL script from shell script. This SQL script will invoke a stored procedure(which has the OUT parameter). I want to have the OUT parameter in the shell script as a variable. Is this possible? (6 Replies)
Discussion started by: vel4ever
6 Replies
9. Shell Programming and Scripting
Hello all,
I am trying to run stored procrdure from shell script which takes one argument. And also I want to verify in the script whether the script executed successfully. However the Stored procedure is not running from shell script. Manually if I run it update the data in the table.
Can... (29 Replies)
Discussion started by: PriyaSri
29 Replies
10. Shell Programming and Scripting
Hi,
I am very new to this environment - I hope this is the right platform to discuss my issue:
I created a CRON job to run a Stored Procedure from our database - Sybase.
Within the Stored Procedure there is a TRUNCATE table and CREATE table function.
the CRON job fails to run with... (2 Replies)
Discussion started by: pizzazzz
2 Replies
LEARN ABOUT DEBIAN
atsadc
ATSADC(1) local ATSADC(1)
NAME
atsadc, atsa1, atsaftp, atsahttp -- counter-collection
SYNOPSIS
atsadc [ t n ] [ ofile ]
atsa1 [ t n ]
atsaftp
atsahttp
DESCRIPTION
System activity-data can be gathered on special request of a user [see atsar(1) ] or automatically, on a routine basis, as described here.
Usually the kernel maintains statistical counters that are incremented as various system actions occur. These include counters for CPU uti-
lization, disk utilization, memory utilization and various network statistics.
The program atsadc and the shell-script atsa1 are used to collect, save, and process these counters.
The program atsadc (the data collector) samples system data n times with an interval of t seconds between samples, and writes in binary
format to ofile or (default) to standard output. The sampling interval t should be greater than 1 second. If t and n are omitted, a special
reset-record is written. This facility is used when booting to a multi-user state, to mark the time at which the counters restart from
zero. For example, the reset-mark can be added to the daily data by the command:
/usr/local/bin/atsadc /var/log/atsar/atsa`date +%d`
Note that this entry is written to the /etc/rc.d/init.d/atsar file.
The shell-script atsa1 is used to collect and store data in the binary file /var/log/atsar/atsadd where dd is the current day of the month.
The arguments t and n cause records to be written n times at an interval of t seconds, or once if omitted. Furthermore this script takes
care that log-files older than a week are removed once a day.
A file containing following entries should be added to the /etc/cron.d directory to produce records every 20 minutes during working hours
and hourly otherwise:
0 * * * 0-6 root /usr/local/bin/atsa1
20,40 8-17 * * 1-5 root /usr/local/bin/atsa1
See crontab(1) for details.
The shell-script atsaftp counts the new transfers registered in the FTP-logfile(s) since the previous time this script was activated; the
new counters are stored in the /var/log/atsar/ftpstat file in ASCII-format. The names of the FTP-logfiles to be watched are specified in
the /etc/atsar.conf configuration-file.
The shell-script atsahttp counts the new transfers registered in the HTTP-logfile(s) since the previous time this script was activated; the
new counters are stored in the /var/log/atsar/httpstat file in ASCII-format. The names of the HTTP-logfiles to be watched are specified in
the /etc/atsar.conf configuration-file.
Both scripts must be activated just before the program atsadc is started, which also collects these counters.
FILES
/var/log/atsar/atsadd
Daily data file, where dd are digits representing the day of the month.
SEE ALSO
atsar(1), crontab(1)
AUTHOR
Gerlof Langeveld, AT Computing (gerlof@ATComputing.nl)
AT Computing July 2004 ATSADC(1)