Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

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

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
mash79
Asked:
mash79
  • 2
  • 2
1 Solution
 
sunnycoderCommented:
Hi mash79,

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

Sunnycoder
0
 
mash79Author Commented:
Thanks.
That way worked.

Is there any way that can actually supress it from sqlplus?
0
 
sunnycoderCommented:
sorry, dont know about that
0
 
mash79Author Commented:
FYI:

set FEEDBACK OFF;

will do it

Thanks all the same.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now