08-06-2007
Search
Please search forums for oft repeated questions. Here is a
link.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
4. UNIX for Dummies Questions & Answers
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
5. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
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.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 Replies
6. Shell Programming and Scripting
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)
Discussion started by: barani75
6 Replies
7. Shell Programming and Scripting
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
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)
Discussion started by: jakSun8
0 Replies
9. Shell Programming and Scripting
Friends,
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
4 Replies
10. 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
1 Replies
FIREFOX(1) Linux User's Manual FIREFOX(1)
NAME
firefox - a Web browser for X11 derived from the Mozilla browser
SYNOPSIS
firefox [OPTIONS] [URL]
DESCRIPTION
Mozilla Firefox is an open-source web browser, designed for standards compliance, performance and portability.
USAGE
firefox is a simple shell script that will set up the environment for the actual executable.
OPTIONS
A summary of the options supported by firefox is included below.
GTK options
--gdk-debug=FLAGS Gdk debugging flags to set
--gdk-no-debug=FLAGS
Gdk debugging flags to unset
--gtk-debug=FLAGS
Gtk+ debugging flags to set
--gtk-no-debug=FLAGS
Gtk+ debugging flags to unset
--gtk-module=MODULE
Load an additional Gtk module
X11 options
--display=DISPLAY
X display to use
--sync Make X calls synchronous
--no-xshm
Don't use X shared memory extension
--xim-preedit=STYLE
--xim-status=STYLE
--g-fatal-warnings
Make all warnings fatal
Firefox options
-h, -help
Show summary of options.
-height value
Set height of startup window to value.
-width value
Set width of startup window to value.
-v, -version
Print /usr/bin/firefox-bin version.
-CreateProfile profile
Create profile.
-P profile
Start with profile.
-ProfileManager
Start with profile manager.
-UILocale lang-region
Start with lang-region resources.
-contentLocale lang-region
Start with lang-region resources.
-remote command
Execute command in an already running Firefox process. For more info, see: http://www.mozilla.org/unix/remote.html
-no-remote
Don't try to control an already running instance.
-jsconsole
Start with Javascript Console
-chrome url
Load the specified chrome.
-new-window url
Open URL in a new window if Firefox is already running.
-new-tab url
Open URL in a new tab if Firefox is already running.
-preferences
Open Firefox preferences menu.
-safe-mode
Disables extensions and themes for this session.
FILES /usr/bin/firefox - shell script wrapping firefox
/usr/lib/firefox/firefox - firefox executable
VERSION
3.0
BUGS
To report a bug, please visit http://bugzilla.mozilla.org/
SEE ALSO
mozilla(1)
AUTHORS
The Mozilla Organization
http://www.mozilla.org/about.html
firefox January 04, 2006 FIREFOX(1)