10 More Discussions You Might Find Interesting
1. How to Post in the The UNIX and Linux Forums
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
2. Shell Programming and Scripting
I'm newbie with ksh so wanting some help....
1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure.
2. Put name1 and name2 value from script run replacing $3 & $4
I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
3. Shell Programming and Scripting
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<< %%
Thanks in advance - jak (0 Replies)
Discussion started by: jakSun8
4. Shell Programming and Scripting
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Discussion started by: shirdi
5. Shell Programming and Scripting
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 )
end;... (6 Replies)
Discussion started by: barani75
6. Shell Programming and Scripting
i am calling a stored procedure from unix shell like this call
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
barani (6 Replies)
Discussion started by: barani75
7. UNIX for Dummies Questions & Answers
My stored procedure returns a value.
How to retrieve the value and display in unix.
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
Unix Scripting i used
sqlplus -s... (7 Replies)
Discussion started by: gohan3376
8. Shell Programming and Scripting
Here's a shell script snippet.....
Retval=`sqlplus -s <<eof
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
9. Shell Programming and Scripting
I have a similar problem to thread 18264, only I couldn't get it to work.
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
10. Shell Programming and Scripting
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:
Now, when I execute my shell script, nothing... (2 Replies)
Discussion started by: priyamurthy2005