Re: WITH HOLD cursors in Oracle stored procs

yong321_at_yahoo.com wrote:
> Sounds like the HOLD_CURSOR option in Oracle pre-compilers.
>
> Yong Huang
>

You led me to find the following:

E121-17, WITH HOLD cursors (in the standard, a cursor is not held through a ROLLBACK, but Oracle does hold through ROLLBACK)

Source:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_standard_sql003.htm#i7719

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)