Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 4.1.3 - Can't see Procedure-Code

3304810Aug 30 2016 — edited Sep 13 2016

I Use SQl Develpoer Version 4.1.3 and i can't see the created Procedure-Code from the Procedures in my Schema. I only get "create or replace" - thats it. No more Code from the Procedure. If i Use TOAD with the same User and the same rights i can see the code of the Procedures.

Here is the Userscript:

DROP USER myUSER CASCADE;                 

                                          

CREATE USER myUSER                        

  IDENTIFIED BY <password>                

  DEFAULT TABLESPACE USERS                

  TEMPORARY TABLESPACE TEMP               

  PROFILE DEFAULT                         

  ACCOUNT UNLOCK;                         

  -- 2 Roles for myUSER                   

  GRANT CONNECT TO myUSER;                

  GRANT RESOURCE TO myUSER;               

  ALTER USER myUSER DEFAULT ROLE ALL;     

  -- 15 System Privileges for myUSER      

  GRANT ALTER SESSION TO myUSER;          

  GRANT CREATE DATABASE LINK TO myUSER;   

  GRANT CREATE JOB TO myUSER;             

  GRANT CREATE MATERIALIZED VIEW TO myUSER;

  GRANT CREATE PROCEDURE TO myUSER;       

  GRANT CREATE SEQUENCE TO myUSER;        

  GRANT CREATE SESSION TO myUSER;         

  GRANT CREATE TABLE TO myUSER;           

  GRANT CREATE TRIGGER TO myUSER;         

  GRANT CREATE VIEW TO myUSER;            

  GRANT DEBUG ANY PROCEDURE TO myUSER;    

  GRANT EXECUTE ANY PROCEDURE TO myUSER;  

  GRANT SELECT ANY SEQUENCE TO myUSER;    

  GRANT SELECT ANY TABLE TO myUSER;       

  GRANT UNLIMITED TABLESPACE TO myUSER; 

What can i do to see the Code?

I can export the Procedures and then i get the full code, So i think i have the rights to see it.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2016
Added on Aug 30 2016
10 comments
2,349 views