Not getting Full text with Dynamic SQL
Hello All, I have a script and I am trying to figure out why my script is not giving me desired output;
DECLARE
l_command_line_1 VARCHAR2 (4000 CHAR);
l_command_line_2 VARCHAR2 (9000 CHAR);
l_command_line_3 VARCHAR2 (4000 CHAR);
l_command_line_4 VARCHAR2 (4000 CHAR);
l_max_rebalance_id NUMBER (9);
v_counter NUMBER := 1;
v_sum NUMBER := 0;
BEGIN
select max (rebalance_id ) into l_max_rebalance_id
from rebalance;
--DBMS_OUTPUT.PUT_LINE ('Max Rebalance ID is: '||l_max_rebalance_id );
-- l_command_line_1 :=
l_command_line_1 :=
'CREATE TABLE wl_llr_Backend_MS1(
rebalance_id Number(9) NULL,
poolnamestr VARCHAR2(256) NULL ,
recordstr VARCHAR2(4000) NULL