How to select a package from database(Oracle)

Question

I code this like a thousand time with different ways "select */text from user_source/all_source/dba_source where name = package name" or "from dba_dependencies" or "and type = 'package' "but it just replies: no rows selected. or its undefined.
when I select all names from user_source i can find it EXISTS. but i cant select that codes and body.
I even create a view "select name from user_source where name = package" it replied: package is not a procedure or undefined, but when i wrote 'package' it creates.

Answer 1

Thank you everyone,
I solved my problem by my self :))
it needs a "upper" before package name(Dbpk_security) , I don't know exactly why but i figured it out that sometimes we need upper for selecting data from database.
I select that package's PLSQL code like this:

Select text from user_source where name=upper('dbpk_security');

Answer 2

these are what i tested.

I tested: select * ...
another time: select text ...
and ect

Answer 3

hi

Answer 4

*/text from user_source/all_source/dba_source