Logotipo Texsa, S.A.
2022-06-27 11:35:06

Error: 2

SELECT * FROM (SELECT a.*, rownum r__ FROM (select t.ID, t.TITOL_NORMALITZAT , GUID_RSS, NO_FOLLOW, VISITES , t.ID_DOC, t.TITOL, TO_CHAR(t.DATA_CREACIO,'dd/mm/yyyy hh24:mi:ss') as DATA_CREACIO, TO_CHAR(t.DATA_MODIFICACIO,'dd/mm/yyyy hh24:mi:ss') as DATA_MODIFICAT, t.TITOL as SEL_CAMP_ORD1, tau_nom_pares(tc.id_categories,tc.id_site,'fr','342','1','S') as TITOL_CAT, tau_ordre_pares(tc.id_categories,tc.id_site,'342','1') as ORDRE_CAT, tc.id_categories from TD_DOCUMENTACIO t, taules_categories tc left join categories ca on (tc.id_categories=ca.id and tc.id_site=ca.id_site and tc.id_taules=ca.id_taules) where t.id_site=1 and t.idioma='fr' and t.validat='S' and t.activat='S' and t.id in (select id_ref from taules_categories where id_site=t.id_site
and id_taules='TD_DOCUMENTACIO' and t.id=id_ref
and instr(tau_retorna_pares(id_categories,id_site),'#342#')>0) and tc.id_site=1 and tc.id_taules='TD_DOCUMENTACIO' and t.id=tc.id_ref and instr(tau_retorna_pares(TC.id_categories,tc.id_site),'#344#')>0
and (ca.privada is null or ca.privada='N'
or (ca.privada='S' and ca.id in (
select gp.id_cat
from usuaris_publica_grups upg, grups_priv_cat_perm gp
where upg.id_site=gp.id_site and upg.id_usu=0 and gp.id_grup_priv=upg.id_grup and gp.id_cat=ca.id))
) order by ORDRE_CAT,SEL_CAMP_ORD1,t.id desc) a WHERE rownum < ((1 * 20) + 1 )) WHERE r__ >= (((1-1) * 20) + 1)

Error executant SQL: oci_execute(): ORA-06553: PLS-306: número o tipos de argumentos erróneos al llamar a 'TAU_ORDRE_PARES'
vars:

id_site:1

user:TEXSA (/webs/texsa2/comu/dbConn.php ->linia 695)

#0 /webs/texsa2/comu/dbConn.php(846): dbConn->execute()
#1 /webs/texsa2/comu/classes/class.Portlet.php(2263): dbConn->paging()
#2 /webs/texsa2/plantilles/base/render/renderPlantillaPortlet.php(26): Portlet->obteRegistres()
#3 /webs/texsa2/comu/classes/class.Render_HTML_base.php(133): renderPlantillaPortlet()
#4 /webs/texsa2/comu/classes/class.Render_HTML_base.php(94): Render_HTML_base->__invoke()
#5 /webs/texsa2/comu/classes/class.Element.php(215): Render_HTML_base->__call()
#6 /webs/texsa2/plantilles/base/render/renderContingut.php(424): Element->render()
#7 /webs/texsa2/plantilles/base/render/renderContingut.php(86): renderAreas()
#8 /webs/texsa2/comu/classes/class.Render_HTML_base.php(133): renderContingut()
#9 /webs/texsa2/comu/classes/class.Render_HTML_base.php(94): Render_HTML_base->__invoke()
#10 /webs/texsa2/comu/classes/class.Element.php(215): Render_HTML_base->__call()
#11 /webs/texsa2/plantilles/base/render/renderPagina.php(774): Element->render()
#12 /webs/texsa2/comu/classes/class.Render_HTML_base.php(133): renderPagina()
#13 /webs/texsa2/comu/classes/class.Render_HTML_base.php(94): Render_HTML_base->__invoke()
#14 /webs/texsa2/comu/classes/class.Element.php(209): Render_HTML_base->__call()
#15 /webs/texsa2/default.php(1752): Element->render()
#16 {main}