Unix call to Oracle PL/SQL pkg/store.proc

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parallel execution of Oracle PROC in UNIX

Hi, Trying to run the Oracle Proc in parallel, but not working.. below code runs each call of the procedure and its coming out of the loop before its completion and printing the last statement! not waiting for the sqlplus to complete. for name in `cat abc.txt` do (sqlplus -s ...

2. Shell Programming and Scripting

Sybase Stored Proc call from UNIX script.

Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with...

3. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i...

4. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

5. Solaris

Pkg problem, one zone trying pkg.Oracle.com on port 1008

Hi Solaris Experts, The pkg utility on one of my non-global zones has stopped working, it's trying to connect to port 1008 at pkg.oracle.com I was using pkg successfully from this zone, but now it's showing this error: lzone1 $ pkg search xterm pkg: Some repositories failed to respond...

6. Shell Programming and Scripting

To call a Oracle sql file 1000 times

Hi Guys, Even though, i have called db2 sql file earlier, this is my first time to call a oracle sql file. I need to make a database(oracle) connection and then call the sql file in a loop. Can you please help me out. Thanks for your help and time. Regards, Magesh

7. Shell Programming and Scripting

Call a pl sql function from unix

hi, I want to know how to call a pl sql function testfunction(param1,..) that returns a value and grab that value in a shell variable. Thnx in advance ---------- Post updated 03-30-10 at 11:58 AM ---------- Previous update was 03-29-10 at 03:49 PM ---------- thnx a lot jim

8. Shell Programming and Scripting

Can SQL Server call be made from unix sh

Hi, I need to make SQL Server procedure call (exec <proc name>)from unix shell script. First of all I would like to know if it is possible. I know we can do it from Oracle but not sure about SQL Server. Version: SunOS 5.8 SQL 8.0 I have made the below entry in the interface file. NSXNA267 ...

9. UNIX for Advanced & Expert Users

How to call SQL procedure from UNIX Shellscript ?

Hi All I would be thankful to you all if you will guide me the steps to call a stored proc. from unix shell script. that stored proc. could be parameterised or parameterless developed in SQL. Any info. in this topic would help me..... Thanks in advance....

10. Shell Programming and Scripting

How to call pl/sql in unix script

sample code as following: test_sql(){ #test#echo test_sql str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM set verify off set heading off set feedback off #--------start pl/sql { DECLARE CURSOR pah_cs IS select id from table where letter = 'abcd';...

LEARN ABOUT MOJAVE

tcl_callwhendeleted

Tcl_CallWhenDeleted(3)					      Tcl Library Procedures					    Tcl_CallWhenDeleted(3)

__________________________________________________________________________________________________________________________________________________

NAME

       Tcl_CallWhenDeleted, Tcl_DontCallWhenDeleted - Arrange for callback when interpreter is deleted

SYNOPSIS

       #include <tcl.h>

       Tcl_CallWhenDeleted(interp, proc, clientData)

       Tcl_DontCallWhenDeleted(interp, proc, clientData)

ARGUMENTS

       Tcl_Interp *interp (in)			     Interpreter with which to associated callback.

       Tcl_InterpDeleteProc *proc (in)		     Procedure to call when interp is deleted.

       ClientData clientData (in)		     Arbitrary one-word value to pass to proc.
_________________________________________________________________

DESCRIPTION

       Tcl_CallWhenDeleted arranges for proc to be called by Tcl_DeleteInterp if/when interp is deleted at some future time.  Proc will be invoked
       just before the interpreter is deleted, but the interpreter will still be valid at the time of the call.  Proc should  have  arguments  and
       result that match the type Tcl_InterpDeleteProc:
	      typedef void Tcl_InterpDeleteProc(
		      ClientData clientData,
		      Tcl_Interp *interp);
       The clientData and interp parameters are copies of the clientData and interp arguments given to Tcl_CallWhenDeleted.  Typically, clientData
       points to an application-specific data structure that proc uses to perform cleanup when an interpreter is about to go away.  Proc does  not
       return a value.

       Tcl_DontCallWhenDeleted	cancels  a previous call to Tcl_CallWhenDeleted with the same arguments, so that proc will not be called after all
       when interp is deleted.	If there is no deletion callback that matches interp, proc, and clientData  then  the  call  to  Tcl_DontCallWhen-
       Deleted has no effect.

KEYWORDS

       callback, delete, interpreter

Tcl									7.0						    Tcl_CallWhenDeleted(3)

Shell Programming and Scripting