Re: ORA 1036 - Oracle 8 - Sporadic Behavior

From: Antoine BRUNEL <antoinebrunel_at_nospam_yahoo.fr>
Date: Fri, 14 Jan 2005 12:05:04 +0100
Message-ID: <41e7a760$0$11253$79c14f64@nan-newsreader-06.noos.net>

Hi from Paris

I already got this kind of error in PHP.... this was when bind variables where not totally filled during the 'execute'.... try debugging by logging bind variables values

<jimit99_at_gmail.com> a écrit dans le message de news: 1105657932.770908.228520_at_c13g2000cwb.googlegroups.com...
> Hi,
>
> I am using Oracle 8.0.6 on HP-UX Server.
>
> We use Pro C routines for deleting entries from Database.
>
> However, we're facing a strange situation wherein the same routine is
> able to delete a row in some cases, but, with exactly the same where
> clause conditions, it fails at other times giving ORA 001036.
>
> calling ERR_FlushErrors
> USST12***************************************************************
> Function: dus_dl_usage; SQLCODE = -1036
> Oracle_message : ORA-01036: illegal variable name/number
>
> Any help would be greatly appreciated.
> Thanks,
> Jimit Shah
> Amdocs Inc
>
Received on Fri Jan 14 2005 - 05:05:04 CST

Re: ORA 1036 - Oracle 8 - Sporadic Behavior - HELP!