CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
Daniel Paczuski Bak
Daniel Paczuski Bak

Reputation: 4080

SQLDeveloper - seeing and modifying procedure code in another schema

How can I see and modify procedure code in another schema? Right now I'm doing 

select * from all_source
where name = 'MY_PROCEDURE'

But that's awful.

Upvotes: 4

Views: 1191

Answers (2)

Dmitriy
Dmitriy

Reputation: 5565

I think, the simplest way is to show a screenshot:

enter image description here

Upvotes: 4

Alex Poole
Alex Poole

Reputation: 191275

In the connections panel expand you connection so you can see the list of object types (tables, views, etc.). Scroll to the bottom of that list and you'll see the last entry is 'Other Users'. Expand that and find the owner of the procedure in that new sub-list. Expand that and scroll down their object type list, expand the 'Procedures' list, and double-click the name of the procedure you're interested in.

That will let you see the source code. To modify it you will need your DBA to grant you the appropriate privileges, if they think it's a valid thing for you to be doing.

If you already have access to the schema you can just create a new connection using that, which would make this simpler.

Upvotes: 3

Related Questions