ORA-4062 using strong ref cursors in the client (forms 5.0)

PACKAGE TEST_PKG IS TYPE TestRec IS RECORD(
theString VARCHAR2(256)
);

TYPE strongRefCursor IS REF CURSOR RETURN TestRec; PROCEDURE OpenCursor (
, v_cursor IN OUT strongRefCursor
);

END TEST_PKG; PACKAGE BODY TEST_PKG IS PROCEDURE OpenCursor(
, v_cursor IN OUT strongRefCursor
);

...

	OPEN v_cursor FOR
		SELECT ‘ABC'
		FROM SYS.DUAL;

END OpenCursor;
END TEST_PKG; Client code looks likes this:

...

	theCursor	TEST_PKG.strongRefCursor;
	theRec	TEST_PKG.TestRec;

TEST_PKG.OpenCursor (
		theCursor
	);
	FETCH theCursor INTO theRec;

I compile form on schema A and run the form. Everything is OK. Then I move TEST_PKG on schema B on the same oracle server and run the form resulting ORA-04062 signature of package TEST_PKG has been changed. The problem involves many customers and many forms and recompiling the forms for each one is not a solution. Now we are using forms 5.0. We notice that in forms 6i everything works fine. But it is very hard to move in a new release at this time. So, I am wondering if it is a known bug solved in a patch on the server and/or client, or if a workaround exists.

We are using Oracle 8.1.7.2.6 on the server and Forms 5.0 patchset 11 on the client.

Any hints would be helpful. Received on Fri Mar 05 2004 - 10:01:20 CET