Re: OIP-04122: Bind variable not fully enabled
Date: Wed, 13 Aug 2003 17:43:17 +0200
Message-ID: <bhdmao$sob$1_at_news-reader1.wanadoo.fr>
[Quoted] 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
>
>
>
Received on Wed Aug 13 2003 - 17:43:17 CEST