Oracle-L: ORA-4062 is driving me crazy !!

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 24 Jan 2003 12:04:21 -0800
Message-ID: <F001.0053A068.20030124120421@fatcity.com>

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!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Jan 24 2003 - 14:04:21 CST