АлександЕР21
12-03-2014, 10:51
ORA-01422: Точная выборка возвращает количество строк больше запрошенного
ORA-06512: на "DEV.D_PKG_HPK_PLAN_JOURNALS", line 1561
SQL: SELECT d.* FROM (SELECT s.*, COUNT(1) over (order by 0) x_rowcount_, ROW_NUMBER() over (order by 0) x_rownum_ FROM (select t.ID,
t.ID||t.HOSP_HISTORY UNIQ_N,
t.LPU,
t.HPK_PLAN THISPLANID,
t.HOSP_PLAN_KIND,
t.HOSP_PLAN_KIND_NAME,
t.PATIENT_ID,
t.PATIENT_AGENT,
(select dec_date from d_hosp_add where direction_id = t.direction and rownum = 1) dec_date,
(select pmc.CARD_NUMB from d_v_persmedcard pmc where pmc.ID = t.PATIENT_ID) CARD_NUMB,
d_pkg_agent_contacts.get_actual_on_date(t.PATIENT_AGENT, sysdate, 'PHONE1') PATIENT_PHONE,
(select d.HOSP_MKB||' '||d.HOSP_MKB_NAME from d_v_directions d where d.ID = t.DIRECTION) HOSP_MKB,
t.PATIENT,
t.PATIENT_BIRTHDATE,
t.DIRECTED_BY_ID,
t.DIRECTED_BY,
t.DIRECTED_TO_ID,
t.DIRECTED_TO,
t.REGISTERED_BY_ID,
trim(t.REGISTERED_BY) REGISTERED_BY,
t.REGISTER_DATE,
t.HAS_PRIVILEGES,
t.SHAS_PRIVILEGES,
t.OPERATION_ID,
t.OPERATION_NAME OPERATION,
t.DIRECTION,
t.PAYMENT_KIND_ID,
t.PAYMENT_KIND,
nvl(t.HOSP_PAYMENT_KIND, t.PAYMENT_KIND) PAYMENT_KIND_NAME,
t.IS_READY,
t.HH_DIRECTION_DATE,
t.IS_OPER,
t.IS_OPER_MNEMO,
t.IS_READY_MNEMO,
t.HP_NAME,
D_PKG_HPK_PLAN_JOURNALS.GET_HOSP_HISTORY_STATUS(t.LPU, t.ID) BEDS,
t.HOSP_HISTORY,
t.HOSP_HISTORY_DS,
t.PLAN_DATE,
(select dir.DIR_COMMENT
from D_V_DIRECTIONS_HPK dir
where dir.ID = t.DIRECTION) COMMENTS,
t.DEPBED,
/*nvl(t.DEP,'---')||'/'||*/t.HOSP_PLAN_KIND_NAME DEP,
t.DIAGNOSIS_FROM,
t.PATIENT_POLIS,
t.COMMENTS PATIENT_CONTACTS,
t.DISEASECASE,
(select dir.DIR_PREF||'/'||dir.DIR_NUMB
from D_V_DIRECTIONS dir
where dir.ID = t.DIRECTION) DIR_PREF_NUMB
from D_V_HPK_PLAN_JOURNALS_ADD t
where t.LPU = :PNLPU
and (((t.HOSP_PLAN_KIND = :PLANIDD or :PLANIDD = -1) and D_PKG_CSE_ACCESSES.CHECK_RIGHT(:PNLPU,'HOSP_PLAN_KINDS',t.HOSP_PLAN_KIND,3,:CABLAB) = 1 and ((:START_DATE is not null and trunc(t.PLAN_DATE) = :START_DATE) or (:START_DATE is null and trunc(t.PLAN_DATE) = trunc(sysdate))))
or
(:PLANIDD is null and t.HPK_PLAN is null))
order by 1) s ) d where x_rownum_ <= :cend_ and x_rownum_ >= :cstart_ order by x_rownum_
OFFSET: 1152
PNLPU => 10903
PLANIDD => -1
START_DATE => 10.03.2014
CABLAB => 75603199
cstart_ => 1
cend_ => 10
PARAMS:
PNLPU => 10903
PLANIDD => -1
START_DATE => 10.03.2014
CABLAB => 75603199
cstart_ => 1
cend_ => 10
На форме HospPlan/hospplan_fwp
Как этот косяк исправить ??
ORA-06512: на "DEV.D_PKG_HPK_PLAN_JOURNALS", line 1561
SQL: SELECT d.* FROM (SELECT s.*, COUNT(1) over (order by 0) x_rowcount_, ROW_NUMBER() over (order by 0) x_rownum_ FROM (select t.ID,
t.ID||t.HOSP_HISTORY UNIQ_N,
t.LPU,
t.HPK_PLAN THISPLANID,
t.HOSP_PLAN_KIND,
t.HOSP_PLAN_KIND_NAME,
t.PATIENT_ID,
t.PATIENT_AGENT,
(select dec_date from d_hosp_add where direction_id = t.direction and rownum = 1) dec_date,
(select pmc.CARD_NUMB from d_v_persmedcard pmc where pmc.ID = t.PATIENT_ID) CARD_NUMB,
d_pkg_agent_contacts.get_actual_on_date(t.PATIENT_AGENT, sysdate, 'PHONE1') PATIENT_PHONE,
(select d.HOSP_MKB||' '||d.HOSP_MKB_NAME from d_v_directions d where d.ID = t.DIRECTION) HOSP_MKB,
t.PATIENT,
t.PATIENT_BIRTHDATE,
t.DIRECTED_BY_ID,
t.DIRECTED_BY,
t.DIRECTED_TO_ID,
t.DIRECTED_TO,
t.REGISTERED_BY_ID,
trim(t.REGISTERED_BY) REGISTERED_BY,
t.REGISTER_DATE,
t.HAS_PRIVILEGES,
t.SHAS_PRIVILEGES,
t.OPERATION_ID,
t.OPERATION_NAME OPERATION,
t.DIRECTION,
t.PAYMENT_KIND_ID,
t.PAYMENT_KIND,
nvl(t.HOSP_PAYMENT_KIND, t.PAYMENT_KIND) PAYMENT_KIND_NAME,
t.IS_READY,
t.HH_DIRECTION_DATE,
t.IS_OPER,
t.IS_OPER_MNEMO,
t.IS_READY_MNEMO,
t.HP_NAME,
D_PKG_HPK_PLAN_JOURNALS.GET_HOSP_HISTORY_STATUS(t.LPU, t.ID) BEDS,
t.HOSP_HISTORY,
t.HOSP_HISTORY_DS,
t.PLAN_DATE,
(select dir.DIR_COMMENT
from D_V_DIRECTIONS_HPK dir
where dir.ID = t.DIRECTION) COMMENTS,
t.DEPBED,
/*nvl(t.DEP,'---')||'/'||*/t.HOSP_PLAN_KIND_NAME DEP,
t.DIAGNOSIS_FROM,
t.PATIENT_POLIS,
t.COMMENTS PATIENT_CONTACTS,
t.DISEASECASE,
(select dir.DIR_PREF||'/'||dir.DIR_NUMB
from D_V_DIRECTIONS dir
where dir.ID = t.DIRECTION) DIR_PREF_NUMB
from D_V_HPK_PLAN_JOURNALS_ADD t
where t.LPU = :PNLPU
and (((t.HOSP_PLAN_KIND = :PLANIDD or :PLANIDD = -1) and D_PKG_CSE_ACCESSES.CHECK_RIGHT(:PNLPU,'HOSP_PLAN_KINDS',t.HOSP_PLAN_KIND,3,:CABLAB) = 1 and ((:START_DATE is not null and trunc(t.PLAN_DATE) = :START_DATE) or (:START_DATE is null and trunc(t.PLAN_DATE) = trunc(sysdate))))
or
(:PLANIDD is null and t.HPK_PLAN is null))
order by 1) s ) d where x_rownum_ <= :cend_ and x_rownum_ >= :cstart_ order by x_rownum_
OFFSET: 1152
PNLPU => 10903
PLANIDD => -1
START_DATE => 10.03.2014
CABLAB => 75603199
cstart_ => 1
cend_ => 10
PARAMS:
PNLPU => 10903
PLANIDD => -1
START_DATE => 10.03.2014
CABLAB => 75603199
cstart_ => 1
cend_ => 10
На форме HospPlan/hospplan_fwp
Как этот косяк исправить ??