Windows Oracle Data Access Components (MOSC)

MOSC Banner

ORA-01008 error

Comments

  • User_61SLE
    User_61SLE Posts: 544 Silver Badge

    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
    John

  • Nip-Oracle
    Nip-Oracle Posts: 757 Gold Badge
     Hi,
    You should post in under "Discussions" section.

    Cheers!
  • User_61SLE
    User_61SLE Posts: 544 Silver Badge
     Hi,
    You should post in under "Discussions" section.

    Cheers!
     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.
    As there hasn't been any reply from the document creator I think it's probably no longer an issue.

    Kind Regards
    John

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center