Call and redirect output of Oracle stored procedure from unix script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Call and redirect output of Oracle stored procedure from unix script
# 1  
Old 03-24-2010
Call and redirect output of Oracle stored procedure from unix script

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

Code:
isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% 
proc_my_test 8
go

%%

Thanks in advance - jak

Last edited by Scott; 03-24-2010 at 06:29 PM.. Reason: Please use code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To call Oracle procedure by reading parameter file in UNIX

hi Guys, is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this file.txt 01-JAN-2015 03-JAN-2015 sqlplus -s user/pwd@DB execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Discussion started by: rohit_shinez
1 Replies

2. Shell Programming and Scripting

ksh and Oracle stored procedure output in logfile

Friends, I pass some runtime arguments (date, number) through ksh script to Oracle procedure, use input value and pass it on to procedure. Oracle procedure gets input value, run query and logs everything in the logfile. I'm facing with couple of challenges 1. Even though I pass all... (5 Replies)
Discussion started by: homer4all
5 Replies

3. Shell Programming and Scripting

Calling Oracle stored procedure from ksh script

Friends, I'm newbie with ksh so wanting some help.... 1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure. 2. Put name1 and name2 value from script run replacing $3 & $4 I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
4 Replies

4. Shell Programming and Scripting

Need to run Oracle stored procedure from UNIX env

Hi Everyone, I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job. Below is my stored procedure:- DECLARE P_TRANSTYPE VARCHAR2(20); ... (4 Replies)
Discussion started by: prasson_ibm
4 Replies

5. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

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

6. Shell Programming and Scripting

how to call oracle stored procedure from unix shell

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

how to pass the values to unix shell from the oracle stored procedure.

Hi i am calling a stored procedure from unix shell like this call test_proc('0002','20100218'); the stored procedure was giving output like this dbms_output.put_line(' processed earlier'); i want to see the output in the unix shell where i called. Thanks barani (6 Replies)
Discussion started by: barani75
6 Replies

8. Shell Programming and Scripting

Need to call stored procedure from unix script

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

9. Shell Programming and Scripting

Invoking Oracle stored procedure in unix shell script

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

10. Shell Programming and Scripting

Calling an Oracle Stored Procedure from Unix shell script

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
Login or Register to Ask a Question
acctdisk(8)						      System Manager's Manual						       acctdisk(8)

NAME
acctdisk, acctdusg - Perform disk-usage accounting SYNOPSIS
acctdisk acctdusg [-u file] [-p file] FLAGS
Searches file as the alternate file for login names and numbers, instead of searching /etc/passwd. Writes records of file names for which it does not charge into file. DESCRIPTION
Normally the acctdisk and acctdusg commands are called from the dodisk shell procedure to do disk-usage accounting. The dodisk shell proce- dure is invoked when the cron daemon executes commands in the /usr/spool/cron/crontabs/[filename] file. In the usual case, the output of the diskusg command is the redirected input to the acctdisk command. When a more thorough, but slower, version of disk accounting is needed, specify the -o flag with the dodisk command. This is not normally done in the /usr/spool/cron/crontabs/[filename] file. When the -o flag is used, the acctdusg command replaces the diskusg command. acctdisk Normally, the acctdisk command reads a temporary output file produced by the diskusg or the acctdusg command from standard input, converts each record into a total disk-accounting record, and writes it to standard output. These records are merged with other accounting records with the acctmerg command to produce a daily accounting report. acctdusg The acctdusg command is called when the -o flag is used with the dodisk command. This produces a more thorough, but slower, version of disk-accounting records. Otherwise, the dodisk shell procedure invokes the diskusg command. The acctdusg command reads a list of files from standard input (usually piped from a find / -print command), computes the number of disk blocks (including indirect blocks) allocated to each file divided by the number of hard links then writes an individual record for each user to standard output. To find the user who is charged for the file, compare each file pathname with the login directories of the users. The user who has the longest pathname component match is charged for the file. Therefore, the relevant information for charging users is not ownership of a file but the directory where it is stored. The acctdusg command searches the /etc/passwd file, or the alternate password file specified with the -p flag, for login names, numbers and login directories. Each output record has the following format: uid login #blocks EXAMPLES
To start normal disk-accounting procedures, add a line similar to the following to the /usr/spool/cron/crontabs/[filename] file: 0 2 * * 4 /usr/sbin/acct/dodisk The foregoing example is a typical, periodically invoked command that the cron daemon reads and executes. The period is expressed by a 6-field entry having the format: mm hh daymon monyr wkday cmd. For any field requiring digits, numbers are integers. These six fields have the following significance: Purpose Time variable that has the value 0 through 59 expressing minutes past the hour. Time variable for the hour of the day in 24-hour clock notation. Time variable for the day of the month. Time variable for month of the year. Time variable for the day or days of the week, where 0 is Sunday and inclusive days are separated with a hyphen (-). Command the cron daemon must execute. Whenever you write any of the time variables described in the foregoing table, an unspecified value must be noted with an * (aster- isk) to define an empty field. In the foregoing example, the dodisk shell procedure runs at 02:00 hours (2) every Thursday (4). The dodisk shell procedure calls the acctdusg command to redirect its input to a temporary file and then calls the acctdisk shell procedure to redirect disk-usage records from the temporary file as input to a /var/adm/acct/nite/[filename] file as output. The file stored in the /var/adm/acct/nite subdirectory is a permanent binary record of disk usage for the specified period. To initiate a slower, more thorough disk-accounting procedure, add a line similar to the following to the /usr/spool/cron/crontabs/[filename] file. 0 2 * * 0-4 /usr/sbin/acct/dodisk -o The dodisk shell procedure calls the acctdusg command and the acctdisk command to write disk-usage records to the /var/adm/acct/nite/[filename] file just as in the previous example. The dodisk procedure runs at 2 a.m. every day (0-6) including Sunday. FILES
Specifies the command path. Specifies the command path. User database file. The active login/logout database file. Accounting header files that define formats for writing accounting files. RELATED INFORMATION
Commands: acct(8), acctmerg(8), cron(8), diskusg(8), dodisk(8), runacct(8) Functions: acct(2) delim off acctdisk(8)