In article <ag1s6i$3ru$1_at_news.solace.mh.se>, pean_at_im.se says...
>
>Hi,
>
>I'm trying to use CLOSE_CACHED_OPEN_CURSORS in Oracle 8.1.7,
>but when I'm starting the server after added this parameter
>to my init.ora I get en error saying it is deprecated.
>
>Is there any other parameter I can use?
>
>Regards,
>Per
>
you don't need it at all anymore. The algorithms changed, the cached open
cursors (cached by plsql) will be closed when and if needed elsewhere in your
session. You no longer need this (hence it is deprecated)
--
Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Thu Jul 04 2002 - 12:56:00 CDT
