Oracle Reports and NESTED TABLES

[fragolita]

Hi all!

Do you know why this query works perfectly in sqlplus and I get an error in Oracle Reports?

select t.doc_id
into num_memo
from jk_address_a ver,
table (select text
from jk_address_a v
where v.person_id = num_person
) t
where ver.person = num_p;

Thanks!
F.

 

[nagornyi]

This is PL/SQL, not SQL code, and you can not run it in the report query. If you run it in the program module (formula, procedure, etc.), please give the full text of the program block and the error message the compiler give.