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

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 28 Jul 2005 13:17:04 GMT
Message-ID: <Xns96A13FF17F35FSunnySD@68.6.19.6>

"Martin T." <bilbothebagginsbab5_at_freenet.de> wrote in news:1122555348.458893.3460_at_z14g2000cwz.googlegroups.com:

> 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
>
>

http://tahiti.oracle.com Received on Thu Jul 28 2005 - 08:17:04 CDT