ASP.NET OracleDataSource PIPELINED function

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

ASP.NET OracleDataSource PIPELINED function

Post by hannes_a » Thu 08 Nov 2012 09:24

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ASP.NET OracleDataSource PIPELINED function

Post by Pinturiccio » Wed 14 Nov 2012 12:50

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.

Post Reply