Forum Stats

  • 3,874,178 Users
  • 2,266,677 Discussions
  • 7,911,757 Comments

Discussions

Could not able to view Procedures

when am trying to view the procedures in sql developer I could not be able to view.

Is any other alternative way to view procedures.?


I have tried with the below query, but no values are populating.

SELECT Text FROM User_Source WHERE Name ='Pr_Log_Error' ORDER BY Line

Tagged:

Best Answer

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,746 Red Diamond
    Answer ✓

    Hi, @User_VG86W

    So the system is telling you yhat you have no access to a procedure (or anything else) named pr_log_error (case insensitive). The system is usually very accurate about things like that. What evidence do you have that there is a procedure with that name?

Answers

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,746 Red Diamond

    Hi, @User_VG86W

    I have tried with the viebelow query, but no values are populating.

    SELECT Text FROM User_Source WHERE Name ='Pr_Log_Error' ORDER BY Line

    Is the procedure named 'Pr_Log_Error', or is it 'PR_LOG_ERROR'? Remember that everything inside quotes is case-sensitive. Identifiers not in quotes are capitalized. for example, the data Tdictionary view is named USER_SOURCE 9all capital letters), but since your query doesn't have it inside quotes, it doesn't matter if any of the letters are capitalized or not. But since the value 'Pr_Log_Error' is inside quotes, it must be entered exactly as it is stored.

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,746 Red Diamond

    Hi, @User_VG86W

    Once again, are you sure the procedure is named 'Pr_Log_Error', with mostly lower-case letters? What do you get when you say

    SELECT DISTINCT  name
    FROM   		 user_source
    WHERE		 UPPER (name) = 'PR_LOG_ERROR';
    

    ?

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,746 Red Diamond

    Hi, @User_VG86W

    So, it looks like you don't have that procedure in your schema at all. Perhaps it's in another schema. Perhaps you can run it without giving a schema name because of a synonym. Try

    SELECT    owner, object_name, object_type
    FROM	  all_objects   
    WHERE	  UPPER (object_name) = 'PR_LOG_ERROR';
    
    
    
  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,746 Red Diamond
    Answer ✓

    Hi, @User_VG86W

    So the system is telling you yhat you have no access to a procedure (or anything else) named pr_log_error (case insensitive). The system is usually very accurate about things like that. What evidence do you have that there is a procedure with that name?