Pipelined Function returns error "Function returned without value"
746035Jan 12 2010 — edited Jan 13 2010*1st* I know a Function must return a value!
I'm using a Pipelined Function called from VB.net report.
The report has been working fine until the search parameters provided by a user resulted in a query with no records; end result the Pipelined Function returns nothing. This causes VB.net to throw the Oracle Error "Function returned without value".
I don't want to modify my VB.net to trap this error because in some cases it may be valid.
How do I make my function return an empty "table" with out creating this error.