Re: PL/SQL: Is a CURSOR always Dynamic SQL ?? (pls-00455)

sybrandb_at_yahoo.com wrote:
> No.
> Your definition of implicit cursor is incorrect.
> Implicit cursor applies to
> - select into
> - insert, update, delete
> OPEN .. -> static cursor, syntactically checked at compile time (*not*
> compiled)
> OPEN FOR ---> dynamic cursor, *NOT* checked at compile time.

I think I do not quite understand -- the select statement after OPEN FOR *is* checked for syntactical correctness. I do not use a dynamic SQL string; just a 'simple' inline select statement.

> (...)
>
> You'll need to read up on PL/SQL, I guess. You are really mixing things
> up big time.
>

:)) Well. I'll be the first one to agree. They should've taken someone who knows PL/SQL, but I was the only one around, so I'll have to do. :)

Btw. - Do you have any book you could recommend for PL/SQL? Something that covers concepts and is maybe also usable as an advanced reference? (I only have Oracle PL/SQL programming 2nd ed. from O'Reilly around -- the german version ... it's missing some chapter from the original and isn't really up to date I guess.)

thanks a lot.
best regards,
Martin Received on Thu Jul 28 2005 - 07:55:48 CDT