Function View -PLSQL Developer

[Kishu]

Hi,

To view function source code[Dev Database], i can able to right click and view and Edit options are available, But when Database is only readonly[Production], we can't even view the Function Source code by right clicking, is there any other ways?

 

[wardy]

Think you'll need to speak to your DBA's. Most production environments dont allow code to be seen. You might be able to see the specs but not the actual code.

 

[Kishu]

No, Actually they have given access to read and we can see the same in SQL Developer and TOAD but why not in PL/SQL Developer?, but i can see from dba_source table. And also i tried enabling the option "Use DBA Views if available" under Oracle => Options. but this also no use.

 

[T-Gergely]

It could be the same bug I reported in 2016.

 

[Kishu]

I didn't get what BUG you're referring, i have select privilege on mentioned tables(DBA_VIEWS) but still i'm not able to view that,but i can view from DBA_SOURCE table