Warning: oci_execute(): ORA-00911: invalid character in /var/www/old.avr.org.ua/html/siteclass.php on line 3747
Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in /var/www/old.avr.org.ua/html/siteclass.php on line 3748
Warning: oci_execute(): ORA-00911: invalid character in /var/www/old.avr.org.ua/html/siteclass.php on line 4336
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, doc.ek23_date, doc.ek23_zagolovok) t_res, (SELECT 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_VARH_DK_SPR_L DOC, GALSLIB.WPU_VARH_CREAT_TBL_L FOND WHERE DOC.ID != 0 and doc.id = FOND.ID_DK_SPR_L and fond.ID_DA_L = ?a=1 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(): ORA-24374: define not done before fetch or execute and fetch in /var/www/old.avr.org.ua/html/siteclass.php on line 4339
Результатів не знайдено