Re: OIP-04122: Bind variable not fully enabled
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 14 Aug 2003 09:03:41 +0100
Message-ID: <3f3b425e$0$15031$ed9e5944_at_reading.news.pipex.net>
Date: Thu, 14 Aug 2003 09:03:41 +0100
Message-ID: <3f3b425e$0$15031$ed9e5944_at_reading.news.pipex.net>
No worries
You might want to take note that I only investigated this because I was curious as to what product OIP related to, I'd never seen that in a message before. You *might* have got a quicker response if you'd mentioned that you were using Oracle Objects for Ole or OO4O in your original post as I know there are people here who use that technology on a daily basis. There was no clue from you post what sort of com object OraDatabase was.
However you did include the error message and error number which far to many people don't.
-- Niall Litchfield Oracle DBA Audit Commission UK "iCS" <oldos_at_wanadoo.fr> wrote in message news:bhdmao$sob$1_at_news-reader1.wanadoo.fr...Received on Thu Aug 14 2003 - 10:03:41 CEST
> Hi Niall !
>
> your advice was very helpfull
> thank you very much ....
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit dans le
> message de news:3f3a46c1$0$18495$ed9e5944_at_reading.news.pipex.net...
> > "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> > news:E2F6A70FE45242488C865C3BC1245DA70410CFD0_at_lnewton.leeds.lfs.co.uk...
> > > Greetings,
> > >
> > > I've got absolutely no idea about ASP but this looks suspicious to me
:
> > >
> > > >> OraDatabase.Parameters.Add "DIR", DIR, ORAPARM_OUTPUT, 1
> > > >> OraDatabase.Parameters.Add "NOM", NOM, ORAPARM_OUTPUT, 1
> > >
> > > I presume the '1' at the end is the posityion of the parameter in the
> > > SQL ? If so, you have both DIR and NOM at position 1.
> > >
> > > If the '1' is not the position, then I'm sorry, I haven't a clue.
> >
> > Hi Norman
> >
> > 1 isn't the position it is the data type (varchar2).
> >
> > The helpfile for Oracle Objects for OLE says that 04122 Bind variable
not
> > enabled is an 'internal error'.
> >
> > The cause of this appears to be not including the oo4o constants in the
> asp
> > page, the resolution would be either include the constants.txt file in
the
> > web page or else replace ORA_PARAMOUTPUT with its actual numerical
value.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> >
> >
> >
>
>