Re: LIKE operator causes server crash

From: Dan Halbert <halbert_at_bbn.com>
Date: Mon, 08 Feb 1999 18:28:19 GMT
Message-ID: <halbert.918498314@franklin>

Following up on my own article:
>We're having a problem with a particular SQL query using the LIKE
>operator sometimes causing the Oracle server to crash, giving
>ORA-03113 (of course) to the remote client.

It turns out that this has nothing to do with LIKE, and was apparently due to a datatype mismatch between Pro*C and PL/SQL. I was passing a char* to a PL/SQL VARCHAR2. Pro*C did not complain. When I added an explicit datatype equivalence declaring the char* as a STRING, the problem went away.

Dan Halbert Received on Mon Feb 08 1999 - 12:28:19 CST