Execute an Oracle stored procedure from a shell scrip


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Execute an Oracle stored procedure from a shell scrip
Prev   Next
# 1  
Old 06-03-2005
Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code:
if [ $FileName != $File ]
then
echo "\n Deleting all reports older than 24 hours. \n" >> $logfile
ls -l $FileName >> $logfile
rm -f $FileName
$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
$DB_id/$DB_pswd@$DB_server
execute RemoveRptFiles($FileName)
EOF

fi

I am getting a syntax error when I add the Oracle connection code. Does anybody kknow what I am doing wrong?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Login or Register to Ask a Question
erl_lint(3erl)						     Erlang Module Definition						    erl_lint(3erl)

NAME
erl_lint - The Erlang Code Linter DESCRIPTION
This module is used to check Erlang code for illegal syntax and other bugs. It also warns against coding practices which are not recom- mended. The errors detected include: * redefined and undefined functions * unbound and unsafe variables * illegal record usage. Warnings include: * unused functions and imports * unused variables * variables imported into matches * variables exported from if / case / receive * variables shadowed in lambdas and list comprehensions. Some of the warnings are optional, and can be turned on by giving the appropriate option, described below. The functions in this module are invoked automatically by the Erlang compiler and there is no reason to invoke these functions separately unless you have written your own Erlang compiler. EXPORTS
module(AbsForms) -> {ok,Warnings} | {error,Errors,Warnings} module(AbsForms, FileName) -> {ok,Warnings} | {error,Errors,Warnings} module(AbsForms, FileName, CompileOptions) -> {ok,Warnings} | {error,Errors,Warnings} Types AbsForms = [term()] FileName = FileName2 = atom() | string() Warnings = Errors = [{Filename2,[ErrorInfo]}] ErrorInfo = see separate description below. CompileOptions = [term()] This function checks all the forms in a module for errors. It returns: {ok,Warnings} : There were no errors in the module. {error,Errors,Warnings} : There were errors in the module. Since this module is of interest only to the maintainers of the compiler, and to avoid having the same description in two places to avoid the usual maintenance nightmare, the elements of Options that control the warnings are only described in compile(3erl) . The AbsForms of a module which comes from a file that is read through epp , the Erlang pre-processor, can come from many files. This means that any references to errors must include the file name (see epp(3erl) , or parser erl_parse(3erl) ). The warnings and errors returned have the following format: [{FileName2,[ErrorInfo]}] The errors and warnings are listed in the order in which they are encountered in the forms. This means that the errors from one file may be split into different entries in the list of errors. is_guard_test(Expr) -> bool() Types Expr = term() This function tests if Expr is a legal guard test. Expr is an Erlang term representing the abstract form for the expression. erl_parse:parse_exprs(Tokens) can be used to generate a list of Expr . format_error(ErrorDescriptor) -> Chars Types ErrorDescriptor = errordesc() Chars = [char() | Chars] Takes an ErrorDescriptor and returns a string which describes the error or warning. This function is usually called implicitly when processing an ErrorInfo structure (see below). ERROR INFORMATION
The ErrorInfo mentioned above is the standard ErrorInfo structure which is returned from all IO modules. It has the following format: {ErrorLine, Module, ErrorDescriptor} A string which describes the error is obtained with the following call: Module:format_error(ErrorDescriptor) SEE ALSO
erl_parse(3erl) , epp(3erl) Ericsson AB stdlib 1.17.3 erl_lint(3erl)