Re: PL/SQL bug ???

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 22 Oct 1998 21:20:12 GMT
Message-ID: <362f92a7.12814522@news.siol.net>

On Thu, 22 Oct 1998 19:20:00 GMT, "Boris Oblak" <boris.oblak_at_siol.net> wrote:

>Yes, PL/SQL doesn't understand INLINE select.

Well, generaly PL/SQL (at least in rel. 7.3) is perfectly aware of inline views an handles them properly. As Thomas Kyte explained, Jarek encountered a bug related to inline views in PL/SQL when there is a UNION inside the inline view. Hovewer, generaly speaking PL/SQL handles views properly. Here is a *very trivial* example to ilustrate this:

SQL> SET SERVEROUTPUT ON
SQL> SELECT DUMMY FROM DUAL; D
-
X

SQL> DECLARE
  2 bla VARCHAR2(80);
  3 BEGIN
  4 SELECT

  5      'DUAL.DUMMY RETRIEVED WITH PL/SQL USING INLINE VIEW: '
  6      ||v1.dummy

  7 INTO bla FROM (SELECT dummy FROM dual) v1;   8 DBMS_OUTPUT.PUT_LINE(bla);
  9 END;
 10 /
DUAL.DUMMY RETRIEVED WITH PL/SQL USING INLINE VIEW: X PL/SQL procedure successfully completed.

>--
>
>Boris
>-------------------------------
>Boris Oblak
>ABAKUS Kranj, d.o.o.
>e-mail: boris.oblak_at_siol.net

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Oct 22 1998 - 16:20:12 CDT