Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem when having Oracle 8 & 7.3.4! Please help

Problem when having Oracle 8 & 7.3.4! Please help

From: Andreia Gaita <shana_at_NOSPAM.viatecla.pt>
Date: Fri, 20 Aug 1999 16:19:43 +0100
Message-ID: <37BD720F.EF3358F2@NOSPAM.viatecla.pt>


Hi everyone!

I'm doing a web site which will run on a Solaris, with an Oracle8 db and Netscape Enterprise Server 3.6.
Seeing as NES is apparently incompatible (ie, can't connect) with Oracle8, I had to installl Oracle 7.3.4 client to serve as an interface. Only now I'm having a problem with one of the .so I made. This .so connects with the db via Oracle7's APIs (ya know, oexfet, olog, etc).

The oexfet function is constantly returning error 1460 when trying to execute this query:

Select * from user where uid = :1 and pwd = :2

From the manual:
"ORA-01460 unimplemented or unreasonable conversion requested

 Cause:

        The requested format conversion is not supported.

 Action:

        Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions

        to see which conversions are supported. "

I'm not doing any conversions, what's wrong?!?!? I'm binding the variables with the obndrn function as usual and executing it with oexfet. The parameters are text (varchar2).

Can someone help me out here?

---
AvG
Developer and otherwise computer nut Received on Fri Aug 20 1999 - 10:19:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US