Warning: oci_execute(): ORA-00936: missing expression in /var/www/old.avr.org.ua/html/siteclass.php on line 4438

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 4439

Warning: oci_execute(): ORA-00936: missing expression in /var/www/old.avr.org.ua/html/siteclass.php on line 3035

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 3038

Notice: Undefined index: ID in /var/www/old.avr.org.ua/html/siteclass.php on line 4447

Notice: Undefined index: DEPTH in /var/www/old.avr.org.ua/html/siteclass.php on line 4447

Notice: Undefined index: NAME_SK in /var/www/old.avr.org.ua/html/siteclass.php on line 4447


• [0]

Warning: oci_execute(): ORA-00936: missing expression in /var/www/old.avr.org.ua/html/siteclass.php on line 2101

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 2104

Warning: oci_execute(): ORA-00936: missing expression in /var/www/old.avr.org.ua/html/siteclass.php on line 4484

Warning: oci_execute(): ORA-00936: missing expression 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) 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 = 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
Результатів не знайдено