Solved

supress PL/SQL procedure completed ... Return value from sql plus

Posted on 2004-08-05
4
313 Views
Last Modified: 2013-12-26
Hi,
 I want to return a value from a oracle stored procedure.

 VALUE=` ${ORACLE_HOME}/bin/sqlplus -s   <<-EOF
                ${ORA_USER}/${ORA_PASSWORD}
                @${SQL_SCRIPT}
        EOF`

        echo $VALUE


I am doing the above, however $VALUE always contains "PL/SQL procedure completed successfully". Is there anyway to supress that last bit? and just return the actual value.
0
Comment
Question by:mash79
  • 2
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
sunnycoder earned 100 total points
ID: 11732900
Hi mash79,

var=`echo $VALUE | sed 's/PL\/SQL procedure completed successfully//'`
echo $var

Sunnycoder
0
 

Author Comment

by:mash79
ID: 11732938
Thanks.
That way worked.

Is there any way that can actually supress it from sqlplus?
0
 
LVL 45

Expert Comment

by:sunnycoder
ID: 11732941
sorry, dont know about that
0
 

Author Comment

by:mash79
ID: 11732974
FYI:

set FEEDBACK OFF;

will do it

Thanks all the same.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
Introduction: Ownerdraw of the grid button.  A singleton class implentation and usage. Continuing from the fifth article about sudoku.   Open the project in visual studio. Go to the class view – CGridButton should be visible as a class.  R…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now