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 -> Re: PLSQL vs SQL Parser

Re: PLSQL vs SQL Parser

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 28 Apr 2005 09:38:18 -0700
Message-ID: <1114706062.323788@yasure>


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

Original text of this message

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