Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Run stored procedure from shell script
Top Forums Shell Programming and Scripting Run stored procedure from shell script Post 302587471 by Rksiva on Thursday 5th of January 2012 04:44:40 AM
Old 01-05-2012
Fine, its seems that you are using Sybase DB then this would be the right syntax to create procedure (as already done by u)

Code:
create proc testing
as
return 1

As suggested by you, using SELECT you can able to store the return value, could you please print that value inside the SQL block and try to redirect it to one flat file. Based on the value we can manipulate using sed or awk command to get the exact return value.

Try like this,

Code:
#!/bin/bash
`isql -Usa -Ppassword -DNP_DB > file_return_value << EOF
declare @returnValue int
exec @returnValue = testing
select ReturnValue=@returnValue
print @returnValue
go
EOF`
echo $ReturnValue
echo last command status : $?
if [ "$OUTPUT" != 0 ]
then
echo "error return from SP"
exit
else
echo "SP return 0"
fi

Also provide me the content of that file (file_return_value)
 

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

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 Replies)
Discussion started by: dorisw
3 Replies

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

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 (0 Replies)
Discussion started by: hema2026
0 Replies

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

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

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; (1 Reply)
Discussion started by: shirdi
1 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

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? (0 Replies)
Discussion started by: vel4ever
0 Replies

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? (6 Replies)
Discussion started by: vel4ever
6 Replies

LEARN ABOUT REDHAT

return

return(n)						       Tcl Built-In Commands							 return(n)

__________________________________________________________________________________________________________________________________________________

NAME

       return - Return from a procedure

SYNOPSIS

       return ?-code code? ?-errorinfo info? ?-errorcode code? ?string?
_________________________________________________________________

DESCRIPTION

       Return  immediately from the current procedure (or top-level command or source command), with string as the return value.  If string is not
       specified then an empty string will be returned as result.

EXCEPTIONAL RETURNS

       In the usual case where the -code option isn't specified the procedure will return normally (its completion code will be TCL_OK).  However,
       the -code option may be used to generate an exceptional return from the procedure.  Code may have any of the following values:

       ok	 Normal return:  same as if the option is omitted.

       error	 Error	return:  same as if the error command were used to terminate the procedure, except for handling of errorInfo and errorCode
		 variables (see below).

       return	 The current procedure will return with a completion code of TCL_RETURN, so that the procedure that invoked it will return also.

       break	 The current procedure will return with a completion code of TCL_BREAK, which will terminate the innermost nested loop in the code
		 that invoked the current procedure.

       continue  The  current  procedure  will	return	with  a completion code of TCL_CONTINUE, which will terminate the current iteration of the
		 innermost nested loop in the code that invoked the current procedure.

       value	 Value must be an integer;  it will be returned as the completion code for the current procedure.

       The -code option is rarely used.  It is provided so that procedures that implement new control structures can  reflect  exceptional  condi-
       tions back to their callers.

       Two  additional	options, -errorinfo and -errorcode, may be used to provide additional information during error returns.  These options are
       ignored unless code is error.

       The -errorinfo option specifies an initial stack trace for the errorInfo variable;  if it is not specified then the  stack  trace  left	in
       errorInfo  will	include the call to the procedure and higher levels on the stack but it will not include any information about the context
       of the error within the procedure.  Typically the info value is supplied from the value left in errorInfo after a catch command trapped	an
       error within the procedure.

       If the -errorcode option is specified then code provides a value for the errorCode variable.  If the option is not specified then errorCode
       will default to NONE.

SEE ALSO

       break(n), continue(n), error(n), proc(n)

KEYWORDS

       break, continue, error, procedure, return

Tcl									7.0								 return(n)
All times are GMT -4. The time now is 02:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy