-
Hey, can anyone tell me the limitations involved with using the UTLDTREE. I actually have two issues related to this utility.
I compiled the script and then ran the following:
(1.)
EXECUTE deptree_fill('TABLE','FIDATA','TRADE_T');
SELECT * FROM IDEPTREE;
DEPENDENCIES
----------------------
TABLE FIDATA.TRADE_T
<no permission>
<no permission>
<no permission>
--- What does "<no permission>" signify?????? ---
(2.)
EXECUTE deptree_fill('VIEW','FIDATA','MARKETDATA_V');
SELECT * FROM IDEPTREE;
DEPENDENCIES
-------------------------------------------------------
VIEW FIDATA.MARKETDATA_V
--- I only get only row for EVERY view i run it against. It seems that none of the views are dependant when ALL views are dependant on other objects, so it cant be correct.
Can anyone help? Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|