Sponsored Content
Top Forums Shell Programming and Scripting Unable to execute Stored Procedure from CRON Post 302604760 by michaelrozar17 on Tuesday 6th of March 2012 12:45:41 AM
Old 03-06-2012
Out of curiosity.. did you run the stored procedure successfully in stand alone mode first rather running through cron..? Because the error seems to be related to database and not with unix environment.
 

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 Replies)
Discussion started by: kamil
2 Replies

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 ... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

3. Shell Programming and Scripting

Stored Procedure on NT/SQLServer

Hi: How will I execute a Stored Procedure that sits on NT/SQLServer. Any help would be appreciated. Thanks (3 Replies)
Discussion started by: mayohan
3 Replies

4. Shell Programming and Scripting

Calling MYSQL Stored Procedure?

Hi, Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script. I have tried the following, (no input params): /usr/bin/mysql -uadmin -ppassword call TL_CLENSEDATA(); resulting in error: /home/hosting/data/scripts/dbclense.sh: line 12: syntax error... (3 Replies)
Discussion started by: kshelluser
3 Replies

5. Shell Programming and Scripting

need to call 3 stored procedure at the same time

Hi GUYS, I need to trigger 3 stored procedure at the same time.. I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful.. Thanks for your help in advance, Magesh (1 Reply)
Discussion started by: mac4rfree
1 Replies

6. Programming

Help with pl/sql stored procedure

Hi, Can anyone please let me know where to check if a particular stored procedure exists. If the procedure exists I want to display some message and if the procedure does not exists i want to exit with error message. checking from dba_objects doesnt help. suprisingly the procedure i... (3 Replies)
Discussion started by: justchill
3 Replies

7. UNIX for Dummies Questions & Answers

Calling stored procedure from unix

Hi, My stored procedure returns a value. How to retrieve the value and display in unix. Stored procedure CREATE OR REPLACE PROCEDURE gohan(num INT) IS BEGIN DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num); END; Unix Scripting i used sqlplus -s... (7 Replies)
Discussion started by: gohan3376
7 Replies

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. (2 Replies)
Discussion started by: dineshmurs
2 Replies

9. Shell Programming and Scripting

Execute stored procedure through script in sybase database and store the output in a .csv file

Hi, I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output. I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies

10. Shell Programming and Scripting

Stored Procedure not executing

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent. sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF set serverout on set feed off set head off set pages 0 set colsep , set tab off set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
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)
All times are GMT -4. The time now is 07:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy