Re: Problem: Oracle view with concatenated columns in java/jdbc app

[This followup was posted to comp.databases.oracle.server and a copy was sent to the cited author.]

In article <354E52AC.11849977_at_internex.net>, tuan_at_internex.net says...
> I have a view with a column defined as follows:
>
> ...
> nvl(first_name,' ')||nvl(middle_name,' ')||nvl(last_name,' ') "Customer Name",
> ...
>
> Within SQLPlus, I can select from this view the Customer Name, which shows all 3
>
> parts of the full name.
> However, in a java/jdbc application, only the first_name shows up.
>
> I tried to modify the view to remove the nvl function:
> ...
> (first_name || middle_name || last_name) "Customer Name",
> ...
> but the changes did not make any difference.
>
> Why couldn't I get all 3 parts of the name in my java application?
>
> Any help will be greatly appreciated.
>
> --Tuan Ho
>
>
>
>

Tuan,
I'm seeing something similar using the ODBC. SQL+ shows the full field length. The ODBC query tool is only giving me the first ~20 characters. The JDBC to ODBC bridge is hanging. I'm interested in solving this too as it is holding up an application which I'm the prime development tester on.

-- 
Dave Bour
Nortel
dbour_at_REMOVEnortel.com

Sorry for the antispamming efforts, to reply 
to me, remove the REMOVE from my email address.