Link to home
Start Free TrialLog in
Avatar of Steve Berger
Steve BergerFlag for United States of America

asked on

Getting error while compiling package from Toad?

Hi,
   I have a toad version 8.6.0.38. I am using Oracle 9i Client. I am accessing the database from my server. Sometimes i will access Oracle 9i server and sometimes Oracle 10g server. When i compile the package or procedure from toad in Oracle 9i. It is complied succesfully. But if i compiled in Oracle 10g it is getting some below message like 'IN is not valid Integer'. I thing this is the toad error. Can any one help me to fix this problem?

Thanks
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

without seeing the code, it's difficult to check out...
Avatar of Steve Berger

ASKER

Hi Angel,
          Attached is my code. Not only this Package, it happens for all the procedure and packages. Please check it and fix this issue.
Thanks
Hi Angel,

         Attached is my code. Not only this Package, it happens for all the procedure and packages. Please check it and fix this issue.

Thanks

XXIBE-VA-PARTY-PERSON-PKG-spec-.doc
XXIBE-VA-PARTY-PERSON-PKG.doc
I don't see anything wrong with the code...
can you please post the full error code(s) and descriptions?
Hi Angel,
       Attached is the error message.
Thanks
ERROR-MESSAGE.doc
well, you could click on "details" ?
this looks like your toad does not fully support oracle 10 databases?...
can you try to compile the package with some other oracle tools?
Yes, if i compile through SQL plus it is working fine. I thing this is the bug in Toad. If i install new version of toad should we rectify this problem???
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good One Angel eyes.