Larry, et. al.,
I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:
alter session set cursor_sharing=force;
select 'x' from dual;
select 'X' from dual;
select ' x' from dual;
select ' X' from dual;
select 'x ' from dual;
select ' x ' from dual;
select ' X ' from dual;
No problems with any of 'em.
Jon Walthour
>--- Original Message ---
>From: "Larry Elkins" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/27/01 12:41:20 PM
>
>Mark,
>
>Thanks for running the test. I would be interested if anyone
could test on
>the latest version of 8.1.7 on Win2000. I called a friend and
had them test
>on the latest release on HP-UX and they couldn't duplicate the
bug.
>
>My inability to duplicate on *my* machine was due to a brain
cramp -- I
>didn't force a hard parse of the statement like I had at the
client. Cursor
>sharing is set to exact on my machine. I tried the statement
with the
>trailing space, it worked. I then set to force and re-executed
with no
>problem. But, the statement wasn't hard parsed since it was
found in the
>shared pool. I can now duplicate without any problem by simply
forcing my
>statement to be hard parsed (just like I was doing on the client's
>machine -- duh!):
>
>SQL> select 'x ' from dual; <<<<< this works (trailing space
which didn't
fail for you)
'x
--
x
sql> alter session set cursor_sharing = force; <<<< change to
force
session altered.
sql> select 'x ' from dual; <<<< still works but it wasn't hard
parsed.
'x
--
x
sql> Select 'x ' from dual; <<<< force a hard parse by changing
lower case s
to upper case
select 'x ' from dual
*
error at line 1:
ora-00600: internal error code, arguments: [17182], [366030328],
[], [], [],
[], [], []
so, it looks like the problem is with just cursor sharing itself
(though it
could still be a mix of parameters -- and i'm not going to try
every
combination!!!).
thanks for the help. i don't know anything else you can do. i
wrapped up the
contract with the client yesterday after taking care of the major
issues i
was brought in to resolve. they can handle this issue and some
other minor
ones. since i *am* curious, i will probably give their dba a
call in a week
or two to see if they and/or oracle solved this with the latest
version and
patches for 8.1.7. and maybe someone on the list will be able
to test
against and up to date 8.1.7 on win2k
regards,
larry g. elkins
[EMAIL PROTECTED]
> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Mark Leith
>> Sent: Friday, July 27, 2001 10:02 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: CURSOR_SHARING = FORCE
>>
>>
>> Larry,
>>
>> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>> With the Partitioning option
>> JServer Release 8.1.7.0.0 - Production
>>
>> >select 'x ' from dual;
>>
>> 'X'
>> --------------------------------
>> x
>>
>> >select 'x' from dual;
>>
>> 'X'
>> --------------------------------
>> x
>>
>> >select ' x' from dual;
>> select ' x' from dual
>> *
>> ERROR at line 1:
>> ORA-00600: internal error code, arguments: [17182], [167886636],
>> [], [], [],
>> [], [], []
>>
>> >alter system set cursor_sharing = exact;
>>
>> System altered.
>>
>> >select ' x' from dual;
>>
>> 'X
>> --
>> x
>>
>> What can I share with you to help you out? This is on a test
>> database only,
>> so just let me know. Also note that the error was only thrown
on
>> mine with a
>> leading space.
>>
>> This is Win2K Professional SP2.
>>
>> Cheers
>>
>> Mark
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Larry Elkins
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
