ODBC RDB String functions

From: Tom Duerr <duerrt_at_decdoc.ksc.nasa.gov>
Date: 1997/04/28
Message-ID: <5k31mf$4pc@niven.ksc.nasa.gov>#1/1

Hi,
I'm using the Oracle for RDB Test utility 1.0.0.1 on NT 4.0 and I'm connecting to a RDB 6.1 database via sql services 7.0 on VMS 6.2

I can do basic selects and they work fine but if I try to do use one of the string functions I get an access violation error.

	Select trim(leading ' ' from msn) from msn 
	    Gives an access violation (works natively on the VAX)	
		 
	Select ltrim(msn) from msn 
	    Gives an unsupported error (doesn't work on the VAX)

Can I do this via the test application?

Thanks
tom

log file:

Oracle ODBC 32 Bit Driver for Rdb Version 2.10.11.0.0 Oracle ODBC 32 Bit Driver for Rdb File Version 2.10.11.0.0

....DSN=prod_db_read; 0X00000000
....0X00067FE0: ODBCTST 0X00000000
....0X00065810: select trim (both ' ' from msn) from msn
....0X00065810: %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtua
....l address=00000066, PC=0078914C, PS=0000001B
Received on Mon Apr 28 1997 - 00:00:00 CDT