strange problem on compile of pl/sql using a db link
I am creating a pl/sql stored proc which has a db link in it.
The SQL does an update
UPDATE tableX@dblink SET DB_SOURCE='S';
The DB_SOURCE is a new field which I just added to the record
however it fails to compile.. even though this SQL works when run normally.
Its as though the compiler is referring to the old record structure.. as though the compiler is compiling against
a cached version of the record structure. Tomorrow I know it will work OK.
Perhaps I need to get everyone to stop using the DB link before it refers to the correct record structure
rather than the old one.
Any ideas ?