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)
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)
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)
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)
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)
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)
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)
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)
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 OSF1
pthread_exc_get_status_np
pthread_exc_get_status_np(3) Library Functions Manual pthread_exc_get_status_np(3)NAME
pthread_exc_get_status_np - (Macro) Obtains a system-defined error status from a DECthreads status exception object.
LIBRARY
DECthreads POSIX 1003.1c Library (libpthread.so)
SYNOPSIS
#include <pthread_exception.h>
int pthread_exc_get_status_np(
EXCEPTION *exception,
unsigned long *code);
STANDARDS
None
PARAMETERS
DECthreads status exception object whose status code is obtained. Receives the system-specific status code associated with the specified
DECthreads status exception object.
DESCRIPTION
This routine obtains and returns the system-specific status value from the DECthreads status exception object specified in the exception
argument. This value must have already been associated with the exception object using the pthread_exc_set_status_np(3) routine.
In a program that uses DECthreads status exceptions, use this routine within a CATCH, CATCH_ALL, or FINALLY code block to obtain the status
code value associated with a caught exception. Note that any exception objects set to the same status value are considered equivalent by
DECthreads.
RETURN VALUES
If an error condition occurs, this routine returns an integer value indicating the type of error. If the routine's exception object argu-
ment is a DECthreads status exception, it sets the code argument and return zero (0). Possible return values are as follows: Successful
completion. The exception argument is not a valid DECthreads status exception object.
ERRORS
None
RELATED INFORMATION
Functions: pthread_exc_set_status_np(3)
Manuals: Guide to DECthreads and Programmer's Guide delim off
pthread_exc_get_status_np(3)