How to view object type from table

Toad for Oracle
1

Hi,
I have data base table it contains a column with object type.
When I try to execute the SQL it says the object type object not found

How to view object type data in

SELECT * FROM table_name; -- This table contain column with object type

2

Welcome to the Toad/Oracle forum...

I don't think Toad's data grid display supports nested types, but you should be able to see the data for your nested types in the Script Output tab, per below. Hope this helps.

image
image1342×830 107 KB

3

Actually, that should work in the grid. Can you give me a small script to create the object(s) and your table, and insert a few rows so that I can reproduce the problem?

4

Guys,

  • Data not being displayed in Schema Browser's RHS Data Grid for such tables
  • Data not displayed in Editor's Data Grid when executing SELECT via Execute Statement mode (F9)
  • Does does get displayed in Editor's Script Output Grid when executing SELECT via Execute as Script mode (F5)

image
image908×612 81.1 KB