Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL vs SQL Parser
amerar_at_iwc.net wrote:
> Hi All,
>
> I have heard that in Oracle 8 the PLSQL parser and the SQL parser are
> different sets of code within the database.
>
> Basically, I wrote a function with some SQL in it. When I run the
> function, I get one value, and when I run just the SELECT statement I
> get a different value.
>
> But, if I change the SQL into a view and use the view inside the
> function, everything works fine.
>
> So, my question is, is there any validity to the PLSQL and SQL parser
> being different in Oracle 8??
>
> Thanks,
>
> Arthur
Yes the SQL and PL/SQL engines are different ... but ...
No DDL
No DML
No HELP
And why are you using a paleolithic, unsupported, version of Oracle for anything?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Apr 28 2005 - 11:38:18 CDT