Home » Developer & Programmer » Reports & Discoverer » ORACLE REPORTS AND NESTED TABLES
ORACLE REPORTS AND NESTED TABLES [message #190842] Fri, 01 September 2006 09:34
Messages: 5
Registered: August 2006
Junior Member
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;

Previous Topic: help plz
Next Topic: pls help
Goto Forum:

Current Time: Fri Oct 21 06:25:39 CDT 2016

Total time taken to generate the page: 0.09967 seconds