sqlplus and dbms_output.put_line in shell script

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
sqlplus and dbms_output.put_line in shell script

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Call sqlplus in the shell script	beaniebear	Shell Programming and Scripting	3	05-13-2008 10:30 AM
help me in sending parameters from sqlplus script to unix shell script	Hara	Shell Programming and Scripting	2	01-29-2008 03:31 PM
Shell Script And SQLPLUS	maco_home	UNIX for Dummies Questions & Answers	6	08-25-2007 01:05 PM
running shell script from sqlplus	dkr123	Shell Programming and Scripting	9	07-20-2006 11:52 PM
passing parameters from a shell script to sqlplus	phani	Shell Programming and Scripting	2	03-13-2005 08:41 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

12-19-2007

stuck1

Registered User

Join Date: Dec 2007

Posts: 5

sqlplus and dbms_output.put_line in shell script

Hi,

I have created a pl/sql block utilises dbms_output.put_line. This script works fine when I call from sqlplus ie sqlplus @./scriptname but when I embed it within my shell script I get no output to screen so I end up with an empty spool file. I know it's executing successfully when called from the shell as I have feedback on and i get the "PL/SQL procedure successfully completed." message.My question is it possible to use dbms_output.put_line within a shell script and to spool the output to file?

Thanks,
S1

Bookmarks

« AIX , unix ftp to windows desktop | parsing email log »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 11:10 PM.