Re: fuction using view with union stops query

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 15 Sep 2007 07:27:05 +0200
Message-ID: <46eb6d26$0$12304$426a74cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1189831416.329876.196340_at_57g2000hsv.googlegroups.com...
| Ive got a view that unions two similar tables
|
| Ive got function that uses that view to find the last record and spits
| out a column.
|
| when i run the function by itself it always work.
|
| I have a simple one table query that has a column that function
| expects. The select works great, when I put in the function nothing is
| returned in the select.
|

Give an example that we can reproduce as well as your Oracle version with 4 decimals.

Regards
Michel Cadot Received on Sat Sep 15 2007 - 00:27:05 CDT