pl/sql procedure compilation error.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: pl/sql procedure compilation error.

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79

    Question

    Hi Guys,


    I have one problem. i have two diffrent database (7.3 and 8.7) i am try ing to compile my procedure that procedure call another procedure from second database using dblink but i am getting error lile PLS.00201 IDENTIFIER MUST BE DECLARE. i don't know why? i also create synonym for that procedure which i am calling from second database using dblink.


    help me out.



    Minesh.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    It could be a rights issue. If it can't see the other procedure then it can't use it.

  3. #3
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    What do i have to do for that?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  5. #5
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    hi marist89,


    Thanks for you help.i do understand that i have to grant privilages to object privilage to user i.egrant execute on to or grant select on to but here my problem is i am call package using dblink from diffrent database to my development database so how i am going to grant priviliges to my development user because i create synonym in my schema and i am the owner of that synonym so i am not sure what to do?


    Thanks

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You have to grant rights on the remote instance to the user that is establishing the connection to the remote db.

    For example, if you create a db link:
    create database link db1 connect to UserA identified by aPassword using 'db1.mydomain.com';

    You then create a synonym that points to UserB.A_TABLE@db1.

    On db1.mydomain.com, the owner of the object (UserB) must grant rights on A_TABLE to UserA.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    privelages

    Hi jeff

    the web site link that explain about roles and privelages is very good and informative.

    Great !!!

    Thanks
    Pravin

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