Re: Insert into my_table select (subquery) on 8.1.7

Użytkownik Matt napisał:

> Mike,
> Sounds like you have a syntax error, which is what the PLS-00103
> refers. Make sure you have semi-colons in the right places.
>

Hope, its syntax error, but i'm affraid is not.

We should remember it's 8.1.7 database, i faced such a problem and with no solution.

It was like:

  INSERT INTO TABLE(x,y,x)
   SELECT a, b, c

     FROM
     (
      SELECT d a, e b, f b
        FROM ....
      );

and all was in PL/SQL procedure which was uncompilable :(

-- 
Noel