10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. Shell Programming and Scripting
How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 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 am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh).
the called stored procedure returns some values through OUT variables
i want to assign the return values of stored procedure in to unix shell script variable.
can you provide me the code.
... (1 Reply)
Discussion started by: barani75
1 Replies
7. Shell Programming and Scripting
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies
8. Shell Programming and Scripting
hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
Discussion started by: Leojhose
2 Replies
9. 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
10. 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
ac(8) System Manager's Manual ac(8)
NAME
ac - Outputs connect-session records
SYNOPSIS
ac [-dp] [-w filename] [user(s) ...]
FLAGS
Outputs the total connect time for each midnight-to-midnight period for which a wtmp file exists. When user(s) is specified, this flag lim-
its the output to the login names specified by any user(s) parameter(s). Outputs the connect time total by individual login name of the
user specified with the -p flag and the user(s) parameter. Omission of this flag permits a total only for the midnight-to-midnight time
period for all logged in users to be produced. Specifies a wtmp file other than the /var/adm/wtmp file. The wtmp file you access for data
may have been created automatically by some shell script administration command (for example, runacct) or manually by the system adminis-
trator when the original /var/adm/wtmp file becomes too large.
DESCRIPTION
The ac command prints to the default output device the total connect time in hours to the nearest hundredth for all users, or the connect
time for any user(s) specified with the -p flag. It also prints the names of users specified by the user(s) parameter who have logged in
during the life of the current /var/adm/wtmp file.
Connect-time records are written by the init and the login programs and are collected in the /var/adm/wtmp file, when such a file exists.
When a /var/adm/wtmp file does not exist, no connect-time accounting records are written; consequently, when connect-time records are
wanted, the system administrator should create a /var/adm/wtmp file that has an initial record length of 0 (zero). Records in wtmp files
(there may be more than one such file) should be processed periodically to keep the files from becoming too large.
When you use the runacct command in a shell script, additional wtmp files can be automatically created whenever the current wtmp file
becomes too large. You can output the contents of any of these other files when you specify the -w flag and the desired wtmp filename.
The ac command is run independently with respect to any accounting shell procedure created or run by any of the acct/* shell procedures or
runacct commands.
EXAMPLES
To obtain an output of the total connect time for all users who have logged in during the life of the current wtmp data file, enter:
/usr/sbin/ac To obtain an output of the total connect time for grossman and mcwhinney as recorded in the default wtmp data file,
enter:
/usr/sbin/ac grossman mcwhinney To obtain an output of the connect time subtotals for grossman and mcwhinney as recorded in the
default wtmp data file, enter:
/usr/sbin/ac -p grossman mcwhinney
FILES
Specifies the command path. Is the active data file for the collection of connect-time records.
RELATED INFORMATION
Commands: login(1), init(8) delim off
ac(8)