declare
   V_ErrorCode   number;
   v_PRS_STR     varchar2(2000);
   vRAISE_ERROR BOOLEAN := FALSE;
begin
	-------All these codes have no error in 10g,But there are some problems in Application Server 11g: 
 	-- The following code (Code A) runs with no error :
	-- Code A : 
	   v_PRS_STR:='begin '||'   insert into hrs_prsntemp values(1,1); commit; ' ||' end;	 ';
  -- But when it changes into the following code (Code B), it causes Error Number: ora-24333.
  -- Code B :
    v_PRS_STR:=
     'begin '||'   insert into hrs_prsntemp  select 1 a,1 b from dual; commit; end;';
      ParseSql_P(v_PRS_STR,V_ErrorCode);
      message(V_ErrorCode);
      
  -- Furthermore, whenever I copy the code of "ParseSql_P" procedure right here,instead of calling that procedure,
  -- It runs correctly with no error!
  -- The most interesting matter is that, if I write code of "B" with syntax error,
  -- it causes Error Number: ora-24333 again 
END;  

PROCEDURE ParseSql_P(P_Sqlstr  In  VARCHAR2,P_ErrorCode Out NUMBER,vRAISE_ERROR BOOLEAN := FALSE) IS
    V_connection_id     EXEC_SQL.CONNTYPE;
    V_cursorID          EXEC_SQL.CURSTYPE;
    V_nIgn              NUMBER;  
    P_Result            NUMBER;    
    V_sqlerrm           varchar2(2000);
    BEGIN
        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,P_Sqlstr, 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;