Page 1 of 1

ASP.NET OracleDataSource PIPELINED function

Posted: Thu 08 Nov 2012 09:24
by 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

Re: ASP.NET OracleDataSource PIPELINED function

Posted: Wed 14 Nov 2012 12:50
by 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.