11-09-2011
Hi durden_tyler,
Thank you so much for the detailed scripts. I am doing the same thing now as you mentioned.
Here is the requirement.
I am passing 4 parameters from the concurrent manager in oracle apps .
param1 is a number data type
param2 is a varchar2 data type ( e.g: this is a test)
param3 and param4 are again number data types.
In the concurrent manager i am calling the korn shell script.
I am accepting the values passed from concurrent manager in korn shell and passing them to the sql script in exactly the same way as you said.
I am getting this error.
error 45 intializing SQL * Plus.
Internal error .
what could be the issue ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
2. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
3. UNIX for Advanced & Expert Users
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Discussion started by: bright_future
4 Replies
4. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
5. Shell Programming and Scripting
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Discussion started by: funonnet
5 Replies
6. Programming
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
Discussion started by: megha2525
14 Replies
7. Shell Programming and Scripting
Hi scripting experts.
I have some coding challenges that I'm hoping you can help me out.
I have one file#1 that contains the following sql statement that spans over multiple lines:
sql Select /*+ use_has(a,b) */ *
from customer a,
customer_address b
where a.id = b.id... (1 Reply)
Discussion started by: pchang
1 Replies
8. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. Shell Programming and Scripting
I have written a script which will take input parameter as another script.
However, if the script passed as input parameter has parameters then this script doesn't work.
I have a script b.ksh which has 1 and 2 as parameters
I have a script c.ksh which has 3,4 and 5 as parameters
vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
LEARN ABOUT OSX
tk_managegeometry
Tk_ManageGeometry(3) Tk Library Procedures Tk_ManageGeometry(3)
__________________________________________________________________________________________________________________________________________________
NAME
Tk_ManageGeometry - arrange to handle geometry requests for a window
SYNOPSIS
#include <tk.h>
Tk_ManageGeometry(tkwin, mgrPtr, clientData)
ARGUMENTS
Tk_Window tkwin (in) Token for window to be managed.
const Tk_GeomMgr *mgrPtr (in) Pointer to data structure containing information about the geometry manager, or NULL to indicate
that tkwin's geometry should not be managed anymore. The data structure pointed to by mgrPtr must
be static: Tk keeps a reference to it as long as the window is managed.
ClientData clientData (in) Arbitrary one-word value to pass to geometry manager callbacks.
_________________________________________________________________
DESCRIPTION
Tk_ManageGeometry arranges for a particular geometry manager, described by the mgrPtr argument, to control the geometry of a particular
slave window, given by tkwin. If tkwin was previously managed by some other geometry manager, the previous manager loses control in favor
of the new one. If mgrPtr is NULL, geometry management is cancelled for tkwin.
The structure pointed to by mgrPtr contains information about the geometry manager:
typedef struct {
const char *name;
Tk_GeomRequestProc *requestProc;
Tk_GeomLostSlaveProc *lostSlaveProc;
} Tk_GeomMgr;
The name field is the textual name for the geometry manager, such as pack or place; this value will be returned by the command winfo man-
ager.
requestProc is a procedure in the geometry manager that will be invoked whenever Tk_GeometryRequest is called by the slave to change its
desired geometry. requestProc should have arguments and results that match the type Tk_GeomRequestProc:
typedef void Tk_GeomRequestProc(
ClientData clientData,
Tk_Window tkwin);
The parameters to requestProc will be identical to the corresponding parameters passed to Tk_ManageGeometry. clientData usually points to
a data structure containing application-specific information about how to manage tkwin's geometry.
The lostSlaveProc field of mgrPtr points to another procedure in the geometry manager. Tk will invoke lostSlaveProc if some other manager
calls Tk_ManageGeometry to claim tkwin away from the current geometry manager. lostSlaveProc is not invoked if Tk_ManageGeometry is called
with a NULL value for mgrPtr (presumably the current geometry manager has made this call, so it already knows that the window is no longer
managed), nor is it called if mgrPtr is the same as the window's current geometry manager. lostSlaveProc should have arguments and results
that match the following prototype:
typedef void Tk_GeomLostSlaveProc(
ClientData clientData,
Tk_Window tkwin);
The parameters to lostSlaveProc will be identical to the corresponding parameters passed to Tk_ManageGeometry.
KEYWORDS
callback, geometry, managed, request, unmanaged
Tk 4.0 Tk_ManageGeometry(3)