Wednesday, 28 August 2013

Catch a PL/SQL procedure's RETURN value in command prompt?

Catch a PL/SQL procedure's RETURN value in command prompt?

Currently im using %testvar%=sqlplus usr/password@schema @test.sql echo
%testvar%
where test.sql calls the procedure using BEGIN END block , and saves the
returned value in a string variable named x , now how do i return this to
command prompt ?

No comments:

Post a Comment