ksh and Oracle stored procedure output in logfile Post: 302931785

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Oracle stored procedure.

I am using sqlplus. I have the stored procedure name. How can i print the stored procedure content?

2. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ...

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

4. Shell Programming and Scripting

calling a PL/SQL stored procedure from KSH

Hi I have a stored procedure which should be called from KSH. Could ayone please help me with this. Thanks

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

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

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

8. Shell Programming and Scripting

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 isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak

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

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

LEARN ABOUT REDHAT

packagens

pkg::create(3tcl)					       Tcl Built-In Commands						 pkg::create(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       pkg::create - Construct an appropriate 'package ifneeded' command for a given package specification

SYNOPSIS

       ::pkg::create -name packageName -version packageVersion ?-load filespec? ... ?-source filespec? ...
_________________________________________________________________

DESCRIPTION

       ::pkg::create  is  a utility procedure that is part of the standard Tcl library.  It is used to create an appropriate package ifneeded com-
       mand for a given package specification.	It can be used to construct a pkgIndex.tcl file for use with the package mechanism.

OPTIONS

       The parameters supported are:

       -name packageName
	      This parameter specifies the name of the package.  It is required.

       -version packageVersion
	      This parameter specifies the version of the package.  It is required.

       -load filespec
	      This parameter specifies a binary library that must be loaded with the load command.  filespec is a list	with  two  elements.   The
	      first  element  is  the name of the file to load.  The second, optional element is a list of commands supplied by loading that file.
	      If the list of procedures is empty or omitted, ::pkg::create will set up the library for direct loading (see pkg_mkIndex).  Any num-
	      ber of -load parameters may be specified.

       -source filespec
	      This  parameter  is  similar to the -load parameter, except that it specifies a Tcl library that must be loaded with the source com-
	      mand.  Any number of -source parameters may be specified.

       At least one -load or -source parameter must be given.

SEE ALSO

       package(3tcl)

KEYWORDS

       auto-load, index, package, version

Tcl									8.3							 pkg::create(3tcl)