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
wxPageSetupDialogData(3erl)				     Erlang Module Definition				       wxPageSetupDialogData(3erl)

NAME
wxPageSetupDialogData - See external documentation: wxPageSetupDialogData. DESCRIPTION
See external documentation: wxPageSetupDialogData . DATA TYPES
wxPageSetupDialogData() : 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
new() -> wxPageSetupDialogData() See external documentation . new(PrintData::wxPrintData() (see module wxPrintData) | wxPageSetupDialogData()) -> wxPageSetupDialogData() See external documentation . enableHelp(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . enableMargins(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . enableOrientation(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . enablePaper(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . enablePrinter(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . getDefaultMinMargins(This::wxPageSetupDialogData()) -> bool() See external documentation . getEnableMargins(This::wxPageSetupDialogData()) -> bool() See external documentation . getEnableOrientation(This::wxPageSetupDialogData()) -> bool() See external documentation . getEnablePaper(This::wxPageSetupDialogData()) -> bool() See external documentation . getEnablePrinter(This::wxPageSetupDialogData()) -> bool() See external documentation . getEnableHelp(This::wxPageSetupDialogData()) -> bool() See external documentation . getDefaultInfo(This::wxPageSetupDialogData()) -> bool() See external documentation . getMarginTopLeft(This::wxPageSetupDialogData()) -> {X::integer(), Y::integer()} See external documentation . getMarginBottomRight(This::wxPageSetupDialogData()) -> {X::integer(), Y::integer()} See external documentation . getMinMarginTopLeft(This::wxPageSetupDialogData()) -> {X::integer(), Y::integer()} See external documentation . getMinMarginBottomRight(This::wxPageSetupDialogData()) -> {X::integer(), Y::integer()} See external documentation . getPaperId(This::wxPageSetupDialogData()) -> integer() See external documentation . getPaperSize(This::wxPageSetupDialogData()) -> {W::integer(), H::integer()} See external documentation . getPrintData(This::wxPageSetupDialogData()) -> wxPrintData() (see module wxPrintData) See external documentation . isOk(This::wxPageSetupDialogData()) -> bool() See external documentation . setDefaultInfo(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . setDefaultMinMargins(This::wxPageSetupDialogData(), Flag::bool()) -> ok See external documentation . setMarginTopLeft(This::wxPageSetupDialogData(), Pt::{X::integer(), Y::integer()}) -> ok See external documentation . setMarginBottomRight(This::wxPageSetupDialogData(), Pt::{X::integer(), Y::integer()}) -> ok See external documentation . setMinMarginTopLeft(This::wxPageSetupDialogData(), Pt::{X::integer(), Y::integer()}) -> ok See external documentation . setMinMarginBottomRight(This::wxPageSetupDialogData(), Pt::{X::integer(), Y::integer()}) -> ok See external documentation . setPaperId(This::wxPageSetupDialogData(), Id::integer()) -> ok See external documentation . setPaperSize(This::wxPageSetupDialogData(), X::integer() | term()) -> ok See external documentation . Alternatives: setPaperSize(This::wxPageSetupDialogData(), Id::integer()) -> ok setPaperSize(This::wxPageSetupDialogData(), Sz::{W::integer(),H::integer()}) -> ok setPrintData(This::wxPageSetupDialogData(), PrintData::wxPrintData() (see module wxPrintData)) -> ok See external documentation . destroy(This::wxPageSetupDialogData()) -> ok Destroys this object, do not use object again AUTHORS
<> wxErlang 0.98.9 wxPageSetupDialogData(3erl)
All times are GMT -4. The time now is 02:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy