Not able to correctly plug PDB on Server

ok I will check & revert back.

No Sir, Its not Privilege issue. I am able to get ddl of the procedure and compile and consume as expected but not getting procedure code in worksheet.

this is the code window snap (Double Click on the Procedure Name).

this is DDL (when I click "Quick DDL > Save to Worksheet")

I get no result from running this code;

DECLARE
  stmt VARCHAR2(32767) := 'WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.Dba_SOURCE
WHERE TYPE = :TYPE AND OWNER = :OWNER AND NAME = :NAME)
SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src) 
WHERE origin_con_id = max_orig
ORDER BY LINE';
  c    INTEGER;
  n    INTEGER;
  rc sys_refcursor;
BEGIN
  C    := SYS.DBMS_SQL.OPEN_CURSOR (FALSE) ;
  SYS.DBMS_SQL.PARSE (C, stmt, DBMS_SQL.NATIVE) ;
  DBMS_SQL.BIND_VARIABLE(C,':TYPE','PROCEDURE');
  DBMS_SQL.BIND_VARIABLE(C,':OWNER','RELYC');
  DBMS_SQL.BIND_VARIABLE(C,':NAME','RSPACCOUNTLIST');
  N := SYS.DBMS_SQL.EXECUTE (C) ;
  SYS.DBMS_SQL.GET_NEXT_RESULT (C, RC) ;
  SYS.DBMS_SQL.RETURN_RESULT (RC, TRUE) ;
  SYS.DBMS_SQL.CLOSE_CURSOR (C) ;
  EXCEPTION
  WHEN NO_DATA_FOUND THEN
  DBMS_OUTPUT.PUT_LINE('NO RECORD FOUND !');
END;

this is result :

I am Using

Oracle 12c 12.1.0.2.0

SQL Developer 4.1.1.19 BUILD MAIN 19.59

Win 8.1 x64

EZ connect method (driver what Oracle SQL developer uses)

User is PDB Administrator

I'm connected to PDB.

Hope this helps

Then why I am getting its DDL??

This is just question

Hi Jeff I have Granted all the privileges to user below is snap from sqlplus, but the problem not solved yet.

Sir Issue Solved Thanks for your time & help.

Sir, I was plugging the pdb using dbca. this time i didn't create new Admin User, instead i granted privilege to the original Admin user of the pdb. this solved the issue. you were correct about the privilege.

still i have to check why  new admin user was not able to see the procedure code after all the privileges given to him.