Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> fuction using view with union stops query

fuction using view with union stops query

From: jobs <jobs_at_webdos.com>
Date: Fri, 14 Sep 2007 21:43:36 -0700
Message-ID: <1189831416.329876.196340@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. Received on Fri Sep 14 2007 - 23:43:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US