-
I didnt got this kind of silly problem ever...
owner = FEDERAL
table = SSN
connect FEDERAL/FEDERAL
desc SSN - works
desc FEDERAL.SSN - works
in dba_objects and dba_segments , the owner is FEDERAL.
When try creating a stored procedure with FEDERAL user,
create procedure myc ( chrec in FEDERAL.SSN%ROWTYPE )
....
this doesnt work.
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/41 PLS-00302: component 'SSN' must be declared
The above procedure works fine if owner reference is ignored.
Happening all tables for only this User schema, othe Schema references are going fine.
Please advice whats wrong here.
Thanx
Jr.
-
Are you sure you're compiling this procedure using Federal user? It should work. But if you are compiling this procedure using another user, it should have select on ssn granted by Federal, otherwise it would get the error you posted.
F.
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
|