Toad World® Forums

Module with cursor used xmltable not show up on package body in schema browser

Hi, I have a PL/SQL package created with private modules which contains cursor using xmltable (see below), I was able to compile the package fine. However, the module DOES NOT show up in the package body in schema browser. Can you please advise why? Thx, Stephen

cursor cur_extract
is
select x.item,
x.frconsumer,
x.fritemdesc,
x.frlegacydesc,
x.frmodel,
x.frcomments
from fr_trans_in_xml_temp,
xmltable (’$d/main/DATA_RECORD’ passing xml_data as “d”
columns
item varchar2(25) path ‘/DATA_RECORD/ITEM’,
frconsumer varchar2(150) path ‘/DATA_RECORD/FRCONSUMER’,
fritemdesc varchar2(35) path ‘/DATA_RECORD/FRITEMDESC’,
frlegacydesc varchar2(19) path ‘/DATA_RECORD/FRLEGACYDESC’,
frmodel varchar2(13) path ‘/DATA_RECORD/FRMODEL’,
frcomments varchar2(250) path ‘/DATA_RECORD/FRCOMMENTS’
) as x;

My TOAD version is 12.5.1.1 xpert edition, Oracle 11g Release 2.

Do you just need to refresh your schema browser? If that’s not it, can you post the whole package? Or enough of it to reproduce the problem?