ASP.NET OracleDataSource PIPELINED function

[hannes_a]

Hello,
I use on ASP.NET a OracleDataSource 5.70.190 in direct mode with this select

Code: Select all

select * from table(packname.functname(:id))

during designtime I can select data, but during runtime I get:

Error occured while parsing the FORM clause: identifier or expression expected

What can I do for workaround ?

By the way:

Code: Select all

with x as (select * form y)
select * from x

doesn't work, but there I found some workarounds

Thank you

[Pinturiccio]

We could not reproduce the issue. Could you please create and send us a small test project with the corresponding DDL/DML scripts for reproducing the issue?

Please also tell us your Oracle Database version.