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)
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
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;... (6 Replies)
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 (0 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
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);
... (4 Replies)
Discussion started by: prasson_ibm
4 Replies
LEARN ABOUT OSF1
false
true(1) General Commands Manual true(1)NAME
true, false - Returns a standard exit value
SYNOPSIS
true
false
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
true: XCU5.0
false: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
DESCRIPTION
The true command returns a 0 (zero) exit value. The false command returns a nonzero exit value. These commands are usually used in input to
shell commands.
NOTES
The special built-in utility : (colon) is sometimes more efficient than the true command.
EXIT STATUS
[Tru64 UNIX] The nonzero value returned by the false command may vary from system to system.
EXAMPLES
To construct a loop in a shell procedure, enter: while true do date sleep 60 done
This procedure displays the date and time once a minute. To stop it, press the Interrupt key sequence.
SEE ALSO
Commands: csh(1), ksh(1), Bourne Shell sh(1b), POSIX shell sh(1p)
Standards: standards(5)true(1)