Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
ORACLE DB with fields NVARCHAR2(510) (Read 2367 times)
pbr
YaBB Newbies
*


I Love SQL*XL

Posts: 2
ORACLE DB with fields NVARCHAR2(510)
21.09.09 at 10:31:11
 
Hi,
i am running a query against an ORACLE DB where fields to be returned are defined as NVARCHAR2(510).
Query runs successfull but all fields with above definition return empty. In the DB they are obviously not empty.
 
Anyone with any idea what's wrong or how to overcome the empty return.
 
Thanks.
Back to top
 
 
  IP Logged
pbr
YaBB Newbies
*


I Love SQL*XL

Posts: 2
Re: ORACLE DB with fields NVARCHAR2(510)
Reply #1 - 22.09.09 at 13:00:14
 
Additional information:
i did some additional testing and found out that when using XLS/CSV as output the data field are all populated.
BTW: i am using EXCEL2007
Back to top
 
 
  IP Logged
Pages: 1