ORA-01008 error
Comments
-
Hello,
First I'd like to point out that you created a document. Documents are good for sharing information.
For questions you would be better creating a Discussion thread - where people can post replies and it's more visible.
You can also subscribe to Discussion threads and get email updates.
So I'd suggest if you recreate a new discussion thread on this. Unfortunately I can't convert this document into a discussion.
As to the problem. ORA-1008 not all variables are bound.
Typically is when the SQL has problems with bind variables
It's unlikely that an upgrade from win 2000 to 2003 would cause the problem.
Is it possible that the client versions are not the same 9.2.0.6.0 ?
Also note 9.2 is a desupported version so I'd recommend upgrading to a supported release such as 11.2.0.x
which can be used with a 9.2.0.4 or later database.
You don't say which interface is used but I'd guess it's either Oracle OLEDB provider (ORAOLEDB) or
Microsoft OLEDB for Oracle (MSDAORA).
If it is the Microsoft provider then can you test with the oracle provider instead as this is the only
provider we support.
Finally it could be related to the use of timestamps.
Can you check if the working ASP are not using timestamps.
If that is the case then it may be related to the connection property CursorLocation .
Excerpts from Oraoledb provider 10g developer Guide
ADO Consumers (page 2-3)
For the Timestamp data types, ADO consumers must specify the value of
CursorLocation as adUseServer and use Recordset for DML operations.
Kind Regards
John0 -
Hi,
You should post in under "Discussions" section.
Cheers!
0 -
Hi,
Hi OraFreak, Just to point out the document and comment above is 4 months old and probably should have been deleted and converted into a discussion at the time.
You should post in under "Discussions" section.
Cheers!
As there hasn't been any reply from the document creator I think it's probably no longer an issue.
Kind Regards
John
0