Thursday, August 21, 2014

Call PLSQL package.function() from shell



OUTPUT_RESPONSE=`sqlplus -s $FCP_LOGIN << EOSQL
!
set term off
set head off
set pages 0
set feedback off
set serveroutput on

declare
retcode NUMBER:=0;
begin
retcode := XXYH_XML_PARSER.PARSE('$SOURCE_CODE', '$l_get_response', $FCP_REQID, $PARENT_REQUEST_ID, '$PROD', '$FEED', '$ACTION','','','','','','','');
dbms_output.put_line(retcode);
end;
/
exit;
!

EOSQL
`


No comments:

Post a Comment