Re: NESTED_TABLE_ID unavailable in PL/SQL?

> Any reason I can access the NESTED_TABLE_ID pseudocolumn in a simple SQL
> query, and not when using the same query in a PL/SQL bloc?
> Any workaround to this problem? TIA.

But this works...( Oracle 8.1.6 )
SQL> create view v_t as
  2 select nested_table_id from table (select nt from t);

View created.

SQL> desc v_t

 Name                                             Null? Type
 ------------------------------- -------- ----
 NESTED_TABLE_ID                          RAW(16)

SQL> begin
  2 declare
  3 x varchar2(100);
  4 begin
  5 select nested_table_id into x from v_t;   6 exception when no_data_found then
  7 dbms_output.put_line('No rows in a table.');   8 end;
  9 end;
 10 /
No rows in a table.

--
TomekB