commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joao Batistella <joao-p-batiste...@ptinovacao.pt>
Subject DBCP + Oracle 8i
Date Sun, 28 Mar 2004 16:25:11 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message