Sponsored Content
Top Forums Programming Executing shell script from PLSQL Post 302405276 by jim mcnamara on Thursday 18th of March 2010 10:09:22 AM
Old 03-18-2010
The only way I know to do what you want in 8i is to write an external C program (OCI)
with a system() call, put it in an external library, and attach it to oracle with tsnlsnr.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Shell script is not executing

Hi, I am trying to execute the below shell script: script name(ss1). ss1 was given permission - 744 before executing. name: ss1 #ss1 #usage:ss1 ls who pwd :wq I tried to execute $ss1 (Enter) Its not executing.... It says that ss1 is not found: echo $SHELL. The o/put i got is... (5 Replies)
Discussion started by: dreams5617
5 Replies

2. UNIX for Dummies Questions & Answers

Executing a Shell Script

I am trying to run a shell script using the ./<ScriptName> command, but the server returns an error bash: ./Script1.sh: Permission denied What variable do I need to set to avoid this? (4 Replies)
Discussion started by: igandu
4 Replies

3. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies

4. Shell Programming and Scripting

Shell Script to Parse PLSQL code?

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (2 Replies)
Discussion started by: gauravsachan
2 Replies

5. Programming

running PLSQL scripts through shell script

I am running the following ealth checks on my server there are two databases in my server . MODEL1 and MODEL2 i connect with the first database as sqlplus model1/password Then i exceute a query select x from table (4 Replies)
Discussion started by: asalman.qazi
4 Replies

6. Shell Programming and Scripting

Execute shell script from plsql trigger

Hi, I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database. On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered... (7 Replies)
Discussion started by: hemant.bs11
7 Replies

7. Shell Programming and Scripting

calling a plsql procedure through shell script

I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell... (4 Replies)
Discussion started by: rspnf
4 Replies

8. Shell Programming and Scripting

Executing a shell script

LD_LIBRARY_PATH=~/tme-0.8/bus/multibus:~/tme-0.8/bus/sbus:~/tme-0.8/dist/softfloat/softfloat/bits32:~/tme-0.8/dist/softfloat/softfloat/bits64:~/tme-0.8/generic:~/tme-0.8/host/bsd:~/tme-0.8/host/gtk:~/tme-0.8/host/posix:~/tme-0.8/ic:~/tme-0.8/ic/ieee754:~/tme-0.8/ic/m68k:~/tme-0.8/ic/sparc:~/tme-0.8/... (1 Reply)
Discussion started by: lucky7456969
1 Replies

9. Shell Programming and Scripting

Executing a shell script using sh

Platform : Solaris 10, RHEL 5.4, OEL 6 I've noticed that some of my colleagues execute scripts by typing sh before the script name sh myscript.shI always execute a script by typing the script name and typing enter provided PATH variable has . (current directory) in it myscript.sh (and... (1 Reply)
Discussion started by: John K
1 Replies

10. Shell Programming and Scripting

Creating IN list in PLSQL script dynamically by using shell script

Hi all, I have a PLSQL script which has a IN list where it takes some ids as input. For example SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID IN (comma separated list ) I want to run this quest inside a shell script but I would like to prepare the IN list dynamically where the employee ids... (1 Reply)
Discussion started by: LoneRanger
1 Replies
wxControlWithItems(3erl)				     Erlang Module Definition					  wxControlWithItems(3erl)

NAME
wxControlWithItems - See external documentation: wxControlWithItems. DESCRIPTION
See external documentation: wxControlWithItems . This class is derived (and can use functions) from: wxControl wxWindow wxEvtHandler DATA TYPES
wxControlWithItems() : An object reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc or distributed for use on other nodes. EXPORTS
append(This::wxControlWithItems(), Item::string()) -> integer() See external documentation . append(This::wxControlWithItems(), Item::string(), ClientData::term()) -> integer() See external documentation . appendStrings(This::wxControlWithItems(), Strings::[[string()]]) -> ok See external documentation . clear(This::wxControlWithItems()) -> ok See external documentation . delete(This::wxControlWithItems(), N::integer()) -> ok See external documentation . findString(This::wxControlWithItems(), S::string()) -> integer() Equivalent to findString(This, S, []) . findString(This::wxControlWithItems(), S::string(), Options::[Option]) -> integer() Types Option = {bCase, bool()} See external documentation . getClientData(This::wxControlWithItems(), N::integer()) -> term() See external documentation . setClientData(This::wxControlWithItems(), N::integer(), ClientData::term()) -> ok See external documentation . getCount(This::wxControlWithItems()) -> integer() See external documentation . getSelection(This::wxControlWithItems()) -> integer() See external documentation . getString(This::wxControlWithItems(), N::integer()) -> string() See external documentation . getStringSelection(This::wxControlWithItems()) -> string() See external documentation . insert(This::wxControlWithItems(), Item::string(), Pos::integer()) -> integer() See external documentation . insert(This::wxControlWithItems(), Item::string(), Pos::integer(), ClientData::term()) -> integer() See external documentation . isEmpty(This::wxControlWithItems()) -> bool() See external documentation . select(This::wxControlWithItems(), N::integer()) -> ok See external documentation . setSelection(This::wxControlWithItems(), N::integer()) -> ok See external documentation . setString(This::wxControlWithItems(), N::integer(), S::string()) -> ok See external documentation . setStringSelection(This::wxControlWithItems(), S::string()) -> bool() See external documentation . AUTHORS
<> wxErlang 0.98.9 wxControlWithItems(3erl)
All times are GMT -4. The time now is 07:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy