NULLS FIRST (or LAST) in PL/SQL's Embedded SQL

Hi All,

I've found PL/SQL's embedded SQL don't
understand NULLS FIRST (or LAST) clause.

procedure test is
  ANames TVarChars;
begin
  SELECT Name
  BULK COLLECT INTO ANames
  FROM MyTable
  ORDER BY Name ASC NULLS FIRST

                                          ^ Error

I'm looking for an (Oracle?) document where differences between SQL and embedded SQL are specified.

Does anybody know?

Sergey Balter Received on Tue Oct 29 2002 - 02:35:09 CST