Warning: ociexecute(): OCIStmtExecute: ORA-00942: 表或视图不存在
in c:\php_439_Win32\includes\db_oracle81.inc on line 190
ORA-00942: 表或视图不存在
Query :"select *
from (select * from (
select A.PROINST_ID AS PROINST_ID,A.ACCEPT_ID AS
ACCEPT_ID,C.FW_ADDRESS,to_char(D.BIRTH_DAY,'yyyy-mm-dd') BIRTH_DAY
from
webadmin_pt.T_proinst A,
webadmin_pt.T_NOWACTINST B,
WEBADMIN_pt.T_HOUSE C,
WEBADMIN_pt.T_FCZS
D,webadmin_pt.RT_FCZS E
where A.PROINST_ID=B.PROINST_ID
and A.PROINST_ID=D.PROINS_ID
and E.FW_NM=C.FW_NM
AND E.FCZ_NM=D.FCZ_NM and d.birth_day>=sysdate-7
and d.PZR is not null
--AND B.actdef_id=68
ORDER BY BIRTH_DAY DESC
) where rownum<=20
minus select * from (
select A.PROINST_ID AS PROINST_ID,A.ACCEPT_ID AS
ACCEPT_ID,C.FW_ADDRESS,to_char(D.BIRTH_DAY,'yyyy-mm-dd') BIRTH_DAY
from
webadmin_pt.T_proinst A,
webadmin_pt.T_NOWACTINST B,
WEBADMIN_pt.T_HOUSE C,
WEBADMIN_pt.T_FCZS
D,webadmin_pt.RT_FCZS E
where A.PROINST_ID=B.PROINST_ID
and A.PROINST_ID=D.PROINS_ID
and E.FW_NM=C.FW_NM
AND E.FCZ_NM=D.FCZ_NM and d.birth_day>=sysdate-7
and d.PZR is not null
--AND B.actdef_id=68
ORDER BY BIRTH_DAY DESC
) where rownum<=0) order by BIRTH_DAY DESC
" Warning: ociexecute(): OCIStmtExecute: ORA-00942: 表或视图不存在
in c:\php_439_Win32\includes\db_oracle81.inc on line 229
Warning: ocifetch(): OCIFetch: ORA-24374: 在读取或执行并读取之前没有完成定义
in c:\php_439_Win32\includes\db_oracle81.inc on line 230
Warning: ocifetchstatement(): OCIFetchStatement: ORA-24374: 在读取或执行并读取之前没有完成定义
in c:\php_439_Win32\includes\db_oracle81.inc on line 243