...

The following line of Pl/SQL code

Code Block

language	xmlsql
title	JITL-PLSQL.job_chain.xml
collapse	true
Example how to specify a return variable

EXEC DBMS_OUTPUT.PUT_LINE( 'SET order_date IS ' || TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD') );

results e.g. in the output

Code Block

language	xmlsql
title	JITL-PLSQL.job_chain.xml
collapse	true
Example for a return variable

SET order_date IS 2021-05-04

...

The std_out_output order variable contains the messages spooled to stdout by PL/SQL.

Space shortcuts

Page tree