Shell arrays in oracle stored procedure Post: 74349

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Oracle stored procedure.

I am using sqlplus. I have the stored procedure name. How can i print the stored procedure content?

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

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 OPENSOLARIS

pdf2dsc

PDF2DSC(1)							 Ghostscript Tools							PDF2DSC(1)

NAME

       pdf2dsc - generate a PostScript page list of a PDF document

SYNOPSIS

       pdf2dsc input.pdf [ output.dsc ]

DESCRIPTION

       pdf2dsc	uses  gs(1) to read an Adobe Portable Document Format (PDF) document "input.pdf" and create a PostScript(tm) document "output.dsc"
       that conforms to Adobe's Document Structuring Conventions (DSC) requirements.

       This new document simply tells Ghostscript to read the PDF file and to display pages one at a time.  The generated  document  can  then	be
       viewed  with  any  PostScript  viewer  based on Ghostscript, like ghostview(1) on Unix or GSview on Windows, with which the user can browse
       through the pages of the PDF document in any order.

       If no output file is named on the command line, the name of the output file is that of the input file with any extension removed,  followed
       by the extension ".dsc".

CAVEATS

       The  DSC document uses Ghostscript-specific procedures.	In addition, the original PDF document must be accessible when the DSC document is
       processed.

       You need the file "pdf2dsc.ps" (originally by Russell Lang) supplied with Ghostscript since release 3.53.

SEE ALSO

       gs(1), ghostview(1)

VERSION

       This document was last revised for Ghostscript version 8.63.

AUTHOR

       Yves Arrouye <yves.arrouye@usa.net> and Russell Lang gsview at ghostgum.com.au

8.63								   1 August 2008							PDF2DSC(1)