PL/SQL SPROC Sub Query Params

> At a guess you are using an oracle 7(.3?) database. The oracle
> documentation is incorrect, the inline view syntax you require does
> not work in a stored procedure. In particular, from my own experience,
> outer joins and some functions cause this syntax error message.
>

I need to be able to control the scope of my sub-queries any manner possible in oracle 7.3. The reason the statement works in dynamic sql is that I have used hard coded date values in place of the start_date and end_date parameters. Is there maybe some method of using a cursor in a sql statement, or selecting from an SPROC. I really need the parameters to work on the base tables themselves as this will give me optimal performance based on indexing. I have in the interim used a seperate view that groups by date which is then narrowed down by a where clause in the main SPROC, and then grouped according to my final grouping requirements.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 03:05:45 CST