The resulting error is in the header.

Oracle database

Request

SELECT * FROM USERS;

USERS is a view, not a table.

And USERS has 1 field whose type contains a link to another table. In tables without such a thing works. I cannot influence the structure of the table, so I have to somehow learn how to work with it.

  • 2
    Well, it seems that something like select * from table(select filed from USERS) but of course you need to take a specific table value from one specific record. - Mike

1 answer 1

Well, for example, if a nested table is not needed - just list the fields you need to get in the query: select field1, field3, field3, ... fieldN from users;

  • Of course it will work. Moreover, I still had to do so. But this is not a solution to the problem but only a way to get around it. I had to poddopilit ActiveRecord that he would have done with Model :: find () -> all (); - Andy
  • but this problem field is a nested table (NESTED TABLE)? it’s just not clear from the task - since the “link to the table” is a simple column that has a foreign key, and, in theory, should not cause such problems. - Eugene Kryukov
  • Yes, this is NESTED TABLE - Andy