Re: PL/SQL Questions

Thanks Vladimir,

It is working now. My Oracle is 8i.

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:b2veik$elg$1_at_babylon.agtel.net...
> What happens to be your Oracle version? Until 9.2, not every
> valid SQL statement was also valid in PL/SQL. Subqueries as
> columns (select (select ...) alias ...) is one such case for 8i.
> You need to use Dynamic SQL (EXECUTE IMMEDIATE) or
> DBMS_SQL for valid SQL statements PL/SQL engine can't
> swallow, or you need to construct a DML statement, which
> will be valid in both SQL and PL/SQL. With 9.2 this is no
> longer a problem - PL/SQL 9.2 understands everything SQL
> does as they use the same engine.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
Received on Thu Feb 20 2003 - 22:39:20 CET