DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Whats the problem here ????

  1. #1
    Join Date
    Jan 2002
    Posts
    148
    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.



  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282


    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
  •  


Click Here to Expand Forum to Full Width