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 -> querying an Oracle memo field with return from Access

querying an Oracle memo field with return from Access

From: <nmadson_at_my-deja.com>
Date: Fri, 21 Jan 2000 23:55:48 GMT
Message-ID: <86arlu$rpr$1@nnrp1.deja.com>


I'm trying to query an Oracle table with a memo field from MS Access. The Access query result is trucated. When I query the field in SQL*Plus I see a solid black square at the point where my results are truncated in Access. I assume this is a carrage return.

Can anyone suggest a method by which I can retrieve the entire contents of the field, perhaps stripping out this entraneous character?

TIA,
Nolan Madson

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 17:55:48 CST

Original text of this message

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