Invalid Package Procedures

I am having certain package procedures. They work OK when called from SQL*Plus. However, calling them through SQL*Forms v3 triggers causes certain strange problems after the package is modified.

Suppose the original package had the specifications as:

	create package mypack as
		procedure oldproc (p1 in char) ;
	end mypack ;

I drop and create another package of the same name as:
	create package mypack as
		procedure newproc (p1 in number, p2 in date) ;
	end mypack ;

My original forms triggers looked like:
	mypack.oldproc ('Hi') ;

I modify them to look like:
	mypack.newproc (1, '1-JAN-96') ;

The problem:

My forms trigger just don't compile any more. They give me an error like 'Procedure not declared'.

However, if I don't change the forms triggers and leave them as it is, the form can be generated without a problem!! The problem now comes at runtime.

It seems that forms are not able to recognise the fact that the package has changed.

I looked through USER_OBJECTS for the entry for the package. The package retains the timestamp of the day it was first created, even though it was dropped and created again later.

It looks like some kind of corruption to me, but I would like to know where: Forms or Database? Also, what should I try to do, short of re-installing everything and re-creating the databases.

Anup.

Anup Computers                                  Tel   : 91-22-364 7992
33, Shankar Sagar                               Fax   : 91-22-363 6176
Sophia College Road
Bombay 400 026                   email : anupcomp_at_giasbm01.vsnl.net.in