Re: error '80020009' on ASP page

From: Alen Cappelletti <alen.cappelletti_at_gmail.com>
Date: 16 Apr 2007 06:38:43 -0700
Message-ID: <1176730723.249848.182240@y80g2000hsf.googlegroups.com>

I try some debug in PL/sql and the problem seems to be that oracle don't find the ID of company.

This is a little part of the dinamic query that build....if I comment this line all works fine...but I have no filtres... 'AND c.IDcompany = PKG_NAVIGAZIONE.is_Azienda('''||StrcookieMD5||''') '||

StrcookieMD5 IN param is not null 'cause I have insert into a TEST table for debug....before call the SQL above.

I use this function....

	FUNCTION is_Azienda(
		strCookieMD5 IN varchar2
	)
	RETURN number

    AS
    Var_IDazienda number;

	BEGIN
       	SELECT
			IDAZIENDA
		INTO
			Var_IDazienda
		FROM UTENTIAPPOGGIONAVIGAZIONE uan
		WHERE PKG_UTILITY.CriptaMD5(uan.IDUTENTEAPPOGGIONAVIGAZIONE||
uan.DATAINSERIMENTO) = strCookieMD5;
        Return Var_IDazienda;
	END is_Azienda;

I try to force return strCookieMD5 union with another field...you know like Company name...but system seems to be block!! ????
I hope some one can hel me.
Alen Italy

On 13 Apr, 17:28, DA Morgan <damor..._at_psoug.org> wrote:
> Alen Cappelletti wrote:
> > Hi all
> > I got this strange error...and I don't know what can I do.
>
> > This is always after a X minutes...simple surfing into pages of my
> > intranet. I don't kwow the real problem 'cause I don't make any
> > action...simple surfing...
>
> > Before of the code belowe I open a connection to the DB with a DNS
> > using oracle ODBC driver.
>
> > I think can be a IIS probem...is it true?
>
> > Cookie od IN param is present ....'cause end at midnight.
> > Someone can help me? Have U sone ideas?
>
> > TNKS Alen
> > -------
> > Set ObjCmdUtente = Server.CreateObject ("ADODB.Command")
> > Set ObjCmdUtente.ActiveConnection = objConn
> > ObjCmdUtente.CommandText = "PKG_NAVIGAZIONE.UTENTE"
> > ObjCmdUtente.CommandType = adCmdStoredProc
>
> > Set param1 = ObjCmdUtente.CreateParameter ( , adBSTR,
> > adParamInput, ,Request.Cookies("Geco2"))
> > ObjCmdUtente.Parameters.Append param1
> > Set ObjRsUtente = ObjCmdUtente.Execute
>
> > Response.write "<img src='Images/"&ObjRsUtente("Logo")&"' alt='logo'
> > hspace='3' border='0' />"
> > -------
>
> Whatever it is ... it has nothing to do with Oracle.
>
> Ask Microsoft for help.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -
Received on Mon Apr 16 2007 - 08:38:43 CDT