begin

       v_PRS_STR:=  'begin  insert into hrs_prsntemp  select 1 a,1 b from dual; commit; end;';
 
        V_connection_id := EXEC_SQL.DEFAULT_CONNECTION;
        V_cursorID      := EXEC_SQL.OPEN_CURSOR(V_connection_id);
        begin
        EXEC_SQL.PARSE(V_connection_id,V_cursorID,v_PRS_STR, exec_sql.V7);    
        
        V_nIgn := EXEC_SQL.EXECUTE(V_connection_id,V_cursorID);
        
        EXCEPTION
            when EXEC_SQL.Package_Error	then 
                P_ErrorCode:=exec_sql.last_error_code(V_connection_id);
                V_sqlerrm:=exec_sql.last_error_mesg(V_connection_id);
                
        END;     
        IF vRAISE_ERROR THEN
            MESSAGE(V_sqlerrm);
            RAISE FORM_TRIGGER_FAILURE;
        END IF;

        EXEC_SQL.CLOSE_CURSOR    (V_connection_id,V_cursorID);
        EXEC_SQL.CLOSE_CONNECTION(V_connection_id);    
      
END;  

bcm@bcm-laptop:~/Downloads$ oerr ora 24333
24333, 00000, "zero iteration count"
// *Cause:  An iteration count of zero was specified for the statement
// *Action: Specify the number of times this statement must be executed