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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 13:13:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.