|
-
Hi,
Are there any restrictions on creating a db procedure using a synonym for a table which is present in the other user?
I am getting an error,
8/1 PL/SQL: SQL Statement ignored
8/55 PLS-00201: identifier 'STRK2.USER_AGENT' must be declared
where strk2.user_agent is a table(name user_agent) in user strk2, for which the synonym is user_agent
can you help
Badrinath
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
|
Reply With Quote