Oracle Shooter

DECLARE l_responsibility_id     NUMBER; l_application_id        NUMBER; l_user_id               NUMBER; l_request_id            NUMBER; xml_layout boolean;  gc_wait_interval   NUMBER          := 0;  v_wait             BOOLEAN;    v_phase            VARCHAR2 (10);    v_status           VARCHAR2 (10);     --   v_out              VARCHAR2 (200); --   v_out1             VARCHAR2 (200); --   po_err_msg         VARCHAR2 (1000);    v_dev_phase        VARCHAR2 (200);    v_dev_status       VARCHAR2 (200);    v_message    ...

  EXECUTE IMMEDIATE dynamic_query [ INTO user_defined_variable_1 , user_defined_variable_2 , .. ] [ USING bind_argument_1 , bind_argument_2 , .. ] [ RETURNING | RETURN-INTO clause ] ;     CASE_1 : NO Value Returning CASE_2 : Returning Single Row with Single Column Value CASE_3 : Returning Single Row with More Than One Column Value CASE_4 : Returning Multiple Row with Single Column Value CASE_5 : Returning Multiple Row with More Than One Column Value     --===================================================     • If the dynamic SQL statement is a "DML statement" without a "RETURNING INTO" clause , other than SELECT, put all bind variables in the "USING" clause . --===================================================   DROP Sequence XX_ROLL_No   DROP TABLE XX_TEMP_TL   Create Sequence XX_ROLL_No Start with 1000   create table XX_TEMP_TL ( Roll_NO ...