Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 4389
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4390
Warning: oci_fetch_array() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4391
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 2986
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 2987
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 2087
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 2088
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 4435
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4436
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 4286
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4288
select count(1) RC from ( select t_res.AUTHORS,t_id.id,t_id.zag,t_id.DATES,t_id.SORT_DATES,ROW_NUMBER() OVER(ORDER BY 1) RN from (select doc.id ID, LISTAGG(pers.name, ' , ') WITHIN GROUP(ORDER BY DOC.ID) AUTHORS FROM GALSLIB.WPU_VDA_APERS_TBL_L pers_tb, GALSLIB.WPU_VDA_APERS_L pers, GALSLIB.WPU_VARH_DK_SPR_L DOC WHERE pers.ID = pers_tb.ID_DA_L AND DOC.ID = pers_tb.ID_DK_SPR_L group by doc.id) t_res, (SELECT /*+ LEADING(TB) */ doc.id ID, doc.ek23_zagolovok , decode(doc.ek23_date, null,EK23_NDATE ,to_char(doc.ek23_date,'DD.MM.YYYY') ) DATES, doc.ek23_zagolovok ZAG , doc.SORT_DATES FROM GALSLIB.WPU_VDA_ARUBR_TBL_L TB, GALSLIB.WPU_VDA_ARUBR_L RUB, GALSLIB.WPU_VARH_DK_SPR_L DOC, GALSLIB.WPU_VDA_ARUBR_L RUB2 WHERE RUB.ID = TB.ID_ARUBR_L AND doc.id = TB.ID_DK_SPR_L and RUB.LINEAGE like rub2.LINEAGE || '%' and rub2.ID = 281 group by DOC.ID, doc.ek23_date, doc.ek23_zagolovok,EK23_NDATE,doc.SORT_DATES) t_id where t_id.id = t_res.ID(+) )
Warning: oci_fetch_array() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4291
Результатів не знайдено
