Re: doesn't work here

Post #32,072 by dshellman 3/13/02 5:13:09 PM Reply	Re: doesn't work here Hmm... Which version of Oracle are you using? I just tried something identical (obviously using a different table structure) and didn't have a problem (that is, it worked fine). I'm using Oracle 8.1.7 (aka Oracle 8i). I didn't try it through sqlplus, though. I was using JDBC, but I don't see why that would have a difference. Dan
Post #32,195 by SpiceWare 3/14/02 2:10:39 PM Reply	Version 7.3.4.0.0 SQLWKS> select * from v$version 2> BANNER ---------------------------------------------------------------- Oracle7 Server Release 7.3.4.0.0 - Production PL/SQL Release 2.3.4.0.0 - Production CORE Version 3.5.4.0.0 - Production TNS for 32-bit Windows: Version 2.3.4.0.0 - Production NLSRTL Version 3.2.4.0.0 - Production 5 rows selected. Darrell Spice, Jr. [link\|http://home.houston.rr.com/spiceware/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #32,234 by dshellman 3/14/02 4:52:41 PM Reply	Re: Version 7.3.4.0.0 That's curious, as I even verified that it works in sqlplus (for version 8.1.7). Apparently, their (Oracle's) handling of SQL between versions has changed, unless there's some other setting involved (and I'm no DBA, so I can't go there). I've no idea of another work around (outside of the obvious, but not trivial, upgrade)...other than one of PL/SQL and a temp table (which is probably more trouble than it's worth). Dan
Post #32,243 by SpiceWare 3/14/02 5:52:59 PM Reply	Wouldn't surprise me That different versions work slightly differently. We've got an upgrade already planned, I think ver 9.x but am not sure. Darrell Spice, Jr. [link\|http://home.houston.rr.com/spiceware/\|SpiceWare] - We don't do Windows, it's too much of a chore

Welcome to IWETHEY!