Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

how to find any Oracle function has has UDT ?

hi,

how to find any Oracle function has has UDT ?
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

"it is User-defined type, in computer science that is generally synonymous with "record", "structure", "composite type" or "class"
"

this is what i want: user define type.
hi man,

I am sorry that, that link is about view, but what I am asking is function has UDT, right?
> marrowyung, you're kinda messing around!
what else is new ?
this one is only function has UDT inside.

but in the other thread, once johnsoon said:

 Now, if the view selects from a function and the function uses dynamic SQL to access ALL_TAB_COLUMNS, then all bets are off, I don't think you could ever find that reference.

Open in new window


I don't see any update on this.
what i think is correct is , Geert G, the first querty you gave here most likely correct as in our test platform it works fine .
1
Geert,

give you mark on this first and query from you seem works.

might need come back for this later.
hi,

will this works:

select distinct a.owner,
                a.object_name,
                a.object_type
  from dba_objects a
  join dba_types c
    on (c.type_name = a.object_type)
 where c.predefined = 'NO'
   and c.type_name = 'FUNCTION' and a.owner ='<schema>'
 order by a.owner,
          a.object_name,
          a.object_type;
          

Open in new window


so this one only show function with UDT ?

which condition is for UDT only ?