Run stored procedure from shell script Post: 302587009

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calling stored procedure from shell script.

Hi All, This is a very starnge problem I am having. I have a shell script that calls a stored procedure. Here's my code in shell script: sqlplus "userid/pwd" @file.sql and file.sql has the following statement: exec my_storedProc; Now, when I execute my shell script, nothing...

2. Shell Programming and Scripting

Calling stored procedure from shell script

HI, I have a similar problem to thread 18264, only I couldn't get it to work. https://www.unix.com/showthread.php?t=18264 I have a stored procedure which is called by a shell script program. When I run the stored procedure alone or through the shell script, it works fine with output text...

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

passing parameter 4m shell script to a DB stored procedure

hi all please tell me how to pass parameters 4m shell script to a DataBase stored procedure. To be specific i have sybase DB. i mean i want the syntax of the command.. how to connect to DB, pass user id and password, pass the required parameter to SP.. .. need ur help frnds.. hema

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

6. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ...

7. Shell Programming and Scripting

Passing a value to stored procedure from unix shell script

Hi Dudes :) I want a unix shell script to pass value to SQL stored procedure. Below is the procedure declare res varchar2(10); begin odm_load_check('PRE_SANITY',res); dbms_output.put_line(res); end; select * from error_log; truncate table error_log; select * from test;

8. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file.

9. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable?

10. Shell Programming and Scripting

How to get OUT parameter of a stored procedure in shell script?

I am invoking a SQL script from shell script. This SQL script will invoke a stored procedure(which has the OUT parameter). I want to have the OUT parameter in the shell script as a variable. Is this possible?

LEARN ABOUT DEBIAN

dchist

DCHIST(1)						DICOM PS3 - DICOM image statistics						 DCHIST(1)

NAME

       dchist - ACR/NEMA DICOM PS3 ... DICOM PS3 - DICOM image statistics

SYNOPSIS

       dchist [ -h|histogram ] [ -csv ] [ -withhighbits|highbitsonly ] [ -v|verbose ] [ -filename ]

DESCRIPTION

       dchist  reads  the named dicom or acr-nema input file and describes the statistics of the image pixel data. The primary intent is to deter-
       mine the zero order entropy of the image.

       The description and verbose output go to standard error.

       The basic input switches are described in dcintro(1). Options specific to this program are:

       -h|histogram
	      Display table of pixel value, frequency, probability, contribution to zero order entropy, and cumulative	zero  order  entropy.  May
	      generate a LOT of output !

       -csv
	      Display only a comma separated value pair of pixel value and frequency, one line per value, e.g., for import into a statistical pro-
	      gram or spreadsheet

       -withhighbits
	      Include as well the values that are above Bits Stored and within Bits Allocated, such  as  might	be  overlay  bits  (regardless	of
	      whether or not there are any 60xx group elements).

       -highbitsonly
	      Use  instead  the  values  that  are above Bits Stored and within Bits Allocated, such as might be overlay bits, and treat all valid
	      pixel values below Bits Stored inclusive as zero (regardless of whether or not there are any 60xx group elements).

       -v|verbose
	      Display byte offset from file start and message start, in hexadecimal, and dump contents while reading and once read.

       -filename
	      Show the name of the file supplied in the arguments; a hyphen will be reported if no filename was supplied.

ENVIRONMENT


EXAMPLES


       % dchist expmeta.dc3
       9.02366 Zero order entropy (bits per pixel)
       0x0     Smallest symbol value
       0       Smallest symbol length (bits)
       0x6e9   Largest symbol value
       11      Largest symbol length (bits)

       % dchist -h expmeta.dc3
       [0x0]   392 p=0.00598145  e=0.0441747   cum=0.0441747
	...
       [0x6e9] 1   p=1.52588e-05 e=0.000244141 cum=9.02366

       9.02366 Zero order entropy (bits per pixel)
       0x0     Smallest symbol value
       0       Smallest symbol length (bits)
       0x6e9   Largest symbol value
       11      Largest symbol length (bits)

FILES


SEE ALSO

       dcstats(1), dcintro(1)

AUTHOR

       Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved.

BUGS

DICOM PS3							  20 August 2007							 DCHIST(1)