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

Thanks!
F.
Previous Topic: help plz
Next Topic: pls help
Goto Forum:
  


Current Time: Wed Dec 07 04:58:28 CST 2016

Total time taken to generate the page: 0.14857 seconds