Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: CURSOR_SHARING = FORCE
Larry,
On
8.1.7.1.5 W2K Pro SP1 No errors:
SQL> select 'x ' from dual;
'X
-- x SQL> select ' x' from dual;Received on Sun Jul 29 2001 - 22:01:43 CDT
'X
-- x SQL> alter system set cursor_sharing=force; System altered. SQL> Select 'x ' from dual;
'X'
-------------------------------- x SQL> Select ' x' from dual;
'X'
-------------------------------- x SQL> This is in a simple test database. If I try it on 8.1.7.1.4 NT4 SP6a - (different parameters, different database) then I get a SQL> select 'x ' from dual;
'X
-- x SQL> select ' x' from dual;
'X
-- x SQL> alter system set cursor_sharing=force; System altered. SQL> Select 'x ' from dual; Select 'x ' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [546660348], [], [], [], [], [], [] Regards, Bruce Reardon -----Original Message----- Sent: Saturday, 28 July 2001 9:16 Thanks to all who replied. So maybe it *is* a combination of things. Here's a recap: 8.1.7.0.0 W2k Ser SP2 Failure 8.1.7.0.0 W2k Pro SP2 Failure 8.1.7.0.0 W2k Pro SP1 Failure 8.1.7.1.1 W2K Pro SP2 Success <<<< 8.1.7.1.1 NT ? ? Failure 8.1.7.1.3 W2K ? ? Failure 8.1.7.1.? HP-UX 11.0 Success <<<< I'll ring the DBA sometime next week and find out what Oracle has to say. Regards, Larry G. Elkins elkinsl_at_flash.net 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
![]() |
![]() |