Hello. I'm using DBCP with an Oracle database and I have some problems with this kind if statements:
select * from TABLE(CAST(GetPhones(cursor(select cust_id,phone1,phone2,phone3,phone4,phone5 from phones)) AS PhoneResultTab)); The error I got in Invalid Column name. I know that the syntax is Oracle specific. Is there a way to solve this without changing the SQL ? Thanks, Joao Paulo.
