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;



'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).