Hi,
I am trying to develop stored procedure universe and getting below error message while trying to insert in universe:
Exception: DBD, ORA-24338: statement handle not executed
State: N/A
I developed SP as below:
CREATE OR REPLACE PROCEDURE CONFLICT_REPORT_BY_DEAL_BO_V2(P_DEAL_ID IN NUMBER,
P_IS_WORKING_COPY IN NUMBER,
conflict_bo_curosr IN OUT
conflict_report_bo_type_pkg.CONFLICT_REPORT_BO_row_type) AS
P_FLAG varchar2(20);
P_DEAL_SYS_ID Number;
BEGIN
if P_IS_WORKING_COPY = 1
then
select deal_sys_id, ‘WORKINGCOPY’
into P_DEAL_SYS_ID , P_FLAG
from deal where deal_id = p_deal_id and is_working_copy = 1 and is_active = 1 and deleted = 0;
else
select deal_sys_id, ‘DEAL’
into P_DEAL_SYS_ID , P_FLAG
from deal where deal_id = p_deal_id and is_latest_version = 1 and is_active = 1 and deleted = 0;
end if;
DELETE FROM CONFLICT_REPORT_BO
WHERE DEAL_ID = DEAL_ID;
Insert into CONFLICT_REPORT_BO (select )
open conflict_bo_curosr for
select * from CONFLICT_REPORT_BO;
END CONFLICT_REPORT_BY_DEAL_BO_V2;
Package:
create or replace package conflict_report_bo_type_pkg
as type CONFLICT_REPORT_BO_row_type IS REF CURSOR RETURN CONFLICT_REPORT_BO%rowtype;
end conflict_report_bo_type_pkg;
Please help me on this.
Thanks,
Mani
popurimani (BOB member since 2013-02-14)