PL/SQL (MOSC)

MOSC Banner

Not getting Full text with Dynamic SQL

edited Dec 9, 2014 1:37PM in PL/SQL (MOSC) 5 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center