-
strange problem on compile of pl/sql using a db link
Hi all,
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 ?
THanks
Jason
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|