Solved

Getting error while compiling package from Toad?

Posted on 2008-10-05
11
1,032 Views
Last Modified: 2013-12-18
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
0
Comment
  • 6
  • 5
11 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22647414
without seeing the code, it's difficult to check out...
0
 

Author Comment

by:Suriyaraj_Sudalaiappan
ID: 22647486
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
0
 

Author Comment

by:Suriyaraj_Sudalaiappan
ID: 22647494
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
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22647502
I don't see anything wrong with the code...
can you please post the full error code(s) and descriptions?
0
 

Author Comment

by:Suriyaraj_Sudalaiappan
ID: 22647518
Hi Angel,
       Attached is the error message.
Thanks
ERROR-MESSAGE.doc
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22647536
well, you could click on "details" ?
0
 

Author Comment

by:Suriyaraj_Sudalaiappan
ID: 22647565
See on this.
ERROR-MESSAGE-1.doc
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22647608
this looks like your toad does not fully support oracle 10 databases?...
can you try to compile the package with some other oracle tools?
0
 

Author Comment

by:Suriyaraj_Sudalaiappan
ID: 22648309
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???
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 22648411
yes, that should solve the problem indeed. current version is 9.7 (released 2 weeks ago):
http://www.toadsoft.com/
0
 

Author Closing Comment

by:Suriyaraj_Sudalaiappan
ID: 31503313
Good One Angel eyes.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
grant user/role question 11 36
having some issue on pl sql procedure 1 29
UTL_FILE invalid file operation 5 45
Password_rules_securitty.. 12 35
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question