in which FP will it be possible to read in SQL data into a variable and use this
later on as a CLPPlus variable ?
This is basic to build variable scripts.
Pinned topic using SQL variables as CLPPlus variables
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-05-09T10:48:34Z at 2011-05-09T10:48:34Z by manshanb
l1t 060000G6BE5 Posts
Re: using SQL variables as CLPPlus variables2011-05-09T05:27:49ZThis is the accepted answer. This is the accepted answer.SQL> var x decimal;
SQL> exec select 1 into :x from dual;
SQL> set serverout on
SQL> exec dbms_output.put_line(:x);