Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LONG field : BO only retrieves first char

Status
Not open for further replies.

srobiolle

IS-IT--Management
Mar 26, 2003
21
0
0
FR
Hello,

I try to use a LONG field (Oracle database). I've made a simple test, with one table containing one field. In the Universe, this field is defined as "Long Text".

When I make a query on this data, BO only returns the first char of each row :
Table =
'AAAAAAAAAAAAAAAAAAAAA...'
'BBBBBBBBBBBBBBBBBBBBB...'

SLQ Query :
SELECT LONG_FIELD FROM MY_TABLE
(works OK in SQL/Plus)

Data returned =
'A'
'B'


Any clues ?

Thanks,
Stephane
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top