Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> INSTR problem into procedure
In this procedure if there is the word "&ID=" into strQueryString
variable IN must be recall an external procedure.
I try to compile this code and always have an PLS error...: PLS-00382 exprerssion is of wrong type at line 59
I dont't understand the problem 'cause in my SQL software a simple
query with INSTR is perfectly on.
Thaks Alen
strCookieMD5 varchar2, strUrl varchar2, strQueryString varchar2, strTitoloPagina varchar2, intArea number, OBJ_CUR_HaiVisto OUT CUR_HaiVisto ) AS BEGIN OPEN OBJ_CUR_HaiVisto FOR SELECT * FROM ( SELECT MAX(un.IDUTENTENAVIGAZIONE) ID, CASE TO_CHAR(NVL(MAX(un.QSTRING),1)) WHEN '1' THEN MAX(un.URLPATH) ELSE MAX(un.URLPATH)||'?'||MAX(un.QSTRING) END QS, CASE SIGN(LENGTH(MAX(un.TITOLOPAGINA))-20) WHEN -1 THEN MAX(un.TITOLOPAGINA) WHEN 1 THEN SUBSTR(MAX(un.TITOLOPAGINA),1,17)||'...' ELSE MAX(un.TITOLOPAGINA) END Titolo, MAX(a.ICONA) Icona FROM UTENTI u JOIN UTENTIAPPOGGIONAVIGAZIONE uan ON (u.IDUTENTE = uan.IDUTENTE) JOIN UTENTINAVIGAZIONE un ON (u.IDUTENTE = un.IDUTENTE) JOIN AREE a USING (IDAREA) WHERE (u.STATO = 1 AND u.SOSPESO = 0) AND
GROUP BY un.URLPATH,un.QSTRING ORDER BY ID DESC ) WHERE rownum <= 10; --Se c'è un ID.... IF INSTR(strQueryString,'&ID=') THEN UTENTENAVIGAZIONE(strCookieMD5,strUrl,strQueryString,strTitoloPagina,intArea); END IF; END HaiVisto;Received on Tue Jun 06 2006 - 08:10:38 CDT