I'm using Oracle 7.3 running on NT 3.51.
Are there restrictions on using "inline" or "immediate" views in stored
procedures? I have a query that runs fine interactively but produces
a compile error when it is placed in a stored procedure.
The error message points to the select statment at the beginning of
the inline view and is...
PLS-00320: the declaration of the type of this
expression is incomplete or malformed
I've gotten some procedures with very simple inline views to compile
without error, but the query I need to run contains aggregates and
a group by and will not compile.
I've look through the oracle documentation. I've found that I can't
use DML inside a procedure, but have been unable to find anything
that says there are restrictions on inline views. Could it be that
most inline views cause an "implied create" and thus fail?
Thanks for any assistance,