Sponsored Content
Top Forums Shell Programming and Scripting Execute an Oracle stored procedure from a shell scrip Post 73739 by jim mcnamara on Friday 3rd of June 2005 03:17:59 PM
Old 06-03-2005
Code:
$ORACLE_HOME/bin/sqlplus -s $DB_id/$DB_pswd@$DB_server<<EOF > oracle.log 
execute RemoveRptFiles($FileName) 
exit
EOF 
fi

assuming you called RemoveRptFiles() correctly and the DB variables actually have correct values - that will work
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell arrays in oracle stored procedure

Is it possible to pass unix shell arrays in Oracle stored procedure? Is yes, how? Thanks (6 Replies)
Discussion started by: superprogrammer
6 Replies

2. 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

3. Shell Programming and Scripting

How to execute an Oracle procedure using shell

Hi , i have created an .sh file that has the following code: #!/bin/ksh sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql & sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF exit EOF The mentioned Procedure_Execute.sql file inside has the following code: exec TEST; ... (5 Replies)
Discussion started by: vins_san
5 Replies

4. 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

5. 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

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 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. (2 Replies)
Discussion started by: dineshmurs
2 Replies

8. Shell Programming and Scripting

Execute a shell script from Oracle procedure

Hi Gurus, Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated. proc_data.sh is script name which I want to execute from oracle procedure It should work something like below procedure test begin... (1 Reply)
Discussion started by: palanisvr
1 Replies

9. Shell Programming and Scripting

Unable to execute Stored Procedure from CRON

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

10. UNIX for Beginners Questions & Answers

Shell script to execute Oracle procedure and trigerring email on success and failure

Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log with no of records. Also if there is any sqlerror then it should write the same in the log file and... (17 Replies)
Discussion started by: senmng
17 Replies
sasl(7) 						   Erlang Application Definition						   sasl(7)

NAME
sasl - The SASL Application DESCRIPTION
This section describes the SASL (System Architecture Support Libraries) application which provides the following services: * alarm_handler * overload * rb * release_handler * systools The SASL application also includes error_logger event handlers for formatting SASL error and crash reports. Note: The SASL application in OTP has nothing to do with "Simple Authentication and Security Layer" (RFC 4422). ERROR LOGGER EVENT HANDLERS
The following error logger event handlers are defined in the SASL application. sasl_report_tty_h : Formats and writes supervisor reports , crash reports and progress reports to stdio . sasl_report_file_h : Formats and writes supervisor reports , crash report and progress report to a single file. error_logger_mf_h : This error logger writes all events sent to the error logger to disk. It installs the log_mf_h event handler in the error_logger process. CONFIGURATION
The following configuration parameters are defined for the SASL application. See app(5) for more information about configuration parame- ters: sasl_error_logger = Value <optional> : Value is one of: tty : Installs sasl_report_tty_h in the error logger. This is the default option. {file,FileName} : Installs sasl_report_file_h in the error logger. This makes all reports go to the file FileName . FileName is a string. false : No SASL error logger handler is installed. errlog_type = error | progress | all <optional> : Restricts the error logging performed by the specified sasl_error_logger to error reports, progress reports, or both. Default is all . error_logger_mf_dir = string() | false<optional> : Specifies in which directory the files are stored. If this parameter is undefined or false , the error_logger_mf_h is not installed. error_logger_mf_maxbytes = integer() <optional> : Specifies how large each individual file can be. If this parameter is undefined, the error_logger_mf_h is not installed. error_logger_mf_maxfiles = 0<integer()<256 <optional> : Specifies how many files are used. If this parameter is undefined, the error_logger_mf_h is not installed. overload_max_intensity = float() > 0 <optional> : Specifies the maximum intensity for overload . Default is 0.8 . overload_weight = float() > 0 <optional> : Specifies the overload weight. Default is 0.1 . start_prg = string() <optional> : Specifies which program should be used when restarting the system. Default is $OTP_ROOT/bin/start . masters = [atom()] <optional> : Specifies which nodes this node uses to read/write release information. This parameter is ignored if the client_directory parameter is not set. client_directory = string() <optional> : This parameter specifies the client directory at the master nodes. Refer to Release Handling in OTP Design Principles for more informa- tion. This parameter is ignored if the masters parameter is not set. static_emulator = true | false <optional> : Indicates if the Erlang emulator is statically installed. A node with a static emulator cannot switch dynamically to a new emulator as the executable files are written into memory statically. This parameter is ignored if the masters and client_directory parameters are not set. releases_dir = string() <optional> : Indicates where the releases directory is located. The release handler writes all its files to this directory. If this parameter is not set, the OS environment parameter RELDIR is used. By default, this is $OTP_ROOT/releases . utc_log = true | false <optional> : If set to true , all dates in textual log outputs are displayed in Universal Coordinated Time with the string UTC appended. SEE ALSO
alarm_handler(3erl) , error_logger(3erl), log_mf_h(3erl), overload(3erl) , rb(3erl) , release_handler(3erl) , systools(3erl) Ericsson AB sasl 2.1.9.3 sasl(7)
All times are GMT -4. The time now is 08:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy