Hi all,
One of our developer has a package (lots of TYPEs, pl/sql table declarations, overloaded function etc). This is being called from
Forms [32 Bit] Version 6.0.8.20.1 (Production)
Oracle Toolkit Version 6.0.8.19.1 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.17.0 Build #863 - Production
Oracle DB is
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
Now, this package was created and compiled on ABCDEV, the form is compiled against ABCDEV, it works fine. But this form when run against ABCTEST, throws 4062 error. If I compile the form against ABCTEST then it works fine on ABCDEV, but fails on ABCDEV.
The package is same, guaranteed ... I used the same script to load the package on both databases.
Now the question is what should we do to resolve this? The function being used returns a pl/sql table declared in the package spec. I had them convert all function to procedures with in/out parameters, same thing.
Any clues will be greatly appreciated
Raj
ps: For anyone interested, I have a 4062 stack trace if you'd like to see it.
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
