unable to see package body on sqldeveloper - SOLVED

Solução :

grants :

GRANT EXECUTE ON  DBMS_METADATA TO user_unable_to_see ;
GRANT CREATE ANY PROCEDURE TO  user_unable_to_see;

Cabe analisar a segurança ao conceder os privilégios acima.

Oks?!!

Julio Cesar Correa

How to use Oracle db service_name in jdbc connection string

simple like that:

using only SID :

jdbc:oracle:thin:@10.1.1.5:1521:mydb

using sid or  service_name :

jdbc:oracle:thin:@10.1.1.5:1521/mydbservice_name

Change " : " to " / " .