Steve Berger
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
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
without seeing the code, it's difficult to check out...
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
Attached is my code. Not only this Package, it happens for all the procedure and packages. Please check it and fix this issue.
Thanks
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
XXIBE-VA-PARTY-PERSON-PKG-spec-.doc
XXIBE-VA-PARTY-PERSON-PKG.doc
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?
can you please post the full error code(s) and descriptions?
ASKER
well, you could click on "details" ?
ASKER
See on this.
ERROR-MESSAGE-1.doc
ERROR-MESSAGE-1.doc
this looks like your toad does not fully support oracle 10 databases?...
can you try to compile the package with some other oracle tools?
can you try to compile the package with some other oracle tools?
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good One Angel eyes.