Oracle stored procedure. Post: 42850

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

LEARN ABOUT HPUX

xaddconnectionwatch

XAddConnectionWatch(3X) 					  XLIB FUNCTIONS					   XAddConnectionWatch(3X)

NAME

       XAddConnectionWatch - handle Xlib internal connections

SYNTAX

       Status XAddConnectionWatch(display, procedure, client_data)
	     Display *display;
	     XConnectionWatchProc procedure;
	     XPointer client_data;

ARGUMENTS

       display	 Specifies the connection to the X server.

       procedure Specifies the procedure to be called.

       client_data
		 Specifies the additional client data.

DESCRIPTION

       The XAddConnectionWatch function registers a procedure to be called each time Xlib opens or closes an internal connection for the specified
       display.  The procedure is passed the display, the specified client_data, the file descriptor for the connection, a Boolean indicating
       whether the connection is being opened or closed, and a pointer to a location for private watch data.  If opening is True, the procedure
       can store a pointer to private data in the location pointed to by watch_data; when the procedure is later called for this same connection
       and opening is False, the location pointed to by watch_data will hold this same private data pointer.

       This function can be called at any time after a display is opened.  If internal connections already exist, the registered procedure will
       immediately be called for each of them, before XAddConnectionWatch returns.  XAddConnectionWatch returns a nonzero status if the procedure
       is successfully registered; otherwise, it returns zero.

       The registered procedure should not call any Xlib functions.  If the procedure directly or indirectly causes the state of internal connec-
       tions or watch procedures to change, the result is not defined.	If Xlib has been initialized for threads, the procedure is called with the
       display locked and the result of a call by the procedure to any Xlib function that locks the display is not defined unless the executing
       thread has externally locked the display using XLockDisplay.

SEE ALSO

       XConnectionWatchProc(3X), XRemoveConnectionWatch(3X), XProcessInternalConnection(3X), XInternalConnectionNumbers(3X)

X Version 11							     Release 6						   XAddConnectionWatch(3X)