Getting below errors while try to execute the below sql.DB version is 12.1.0.2.
1 BEGIN
2 PRINT_TABLE('
3 WITH D1 AS(
4 SELECT INST_ID,RESOURCE_NAME1,GRANT_LEVEL,REQUEST_LEVEL,
5 TRANSECTION_ID0,which_queue,state,pid,blocked,blocker
6 from gv$ges_blocking_enqueue
7 )
8 select d1.inst_id,d1.resource_name1,d1.grant_level,
9 d1.request_level,d1.state,s.sid,sw.event,
10 sw.seconds_in_wait sec
11 from d1
12 gv$process p,gv$session s,gv$session_wait sw
13 where(d1.inst_id = p.inst_id and d1.pid =p.spid)
14 and (p.inst_id =s.inst_id and p.addr =s.paddr)
15 and (s.inst_id =sw.inst_id and s.sid =sw.sid)
16 order by sw.seconds_in_wait desc');
17* end;
/
PRINT_TABLE('
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'PRINT_TABLE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored