Home » SQL & PL/SQL » SQL & PL/SQL » case insensitive search (10g)
case insensitive search [message #440718] Tue, 26 January 2010 15:20 Go to next message
hiswapna
Messages: 6
Registered: December 2005
Location: Hyderabad
Junior Member
I have set the parameters
NLS_COMP=LINGUISTIC';

NLS_SORT=BINARY_CI';
both at session level and system level.

when I execute queries @ sql plus client or from toad everything works fine
but when the procedure is called from JDBC adapater to connect to database the case insensitive search is not working. The server side is Webshphere (WID).

Please help me what might be going wrong..
Re: case insensitive search [message #440720 is a reply to message #440718] Tue, 26 January 2010 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
>when I execute queries @ sql plus client or from toad everything works fine
>but when the procedure is called from JDBC adapater to connect to database the case insensitive search is not working. The server side is Webshphere (WID).
>Please help me what might be going wrong..

Problem is external to Oracle RDBMS.

Just curious JDBC thin or thick client & which version?
Re: case insensitive search [message #440723 is a reply to message #440720] Tue, 26 January 2010 15:28 Go to previous messageGo to next message
hiswapna
Messages: 6
Registered: December 2005
Location: Hyderabad
Junior Member
we are using JDBC Outbound 6.1 Adapter
Re: case insensitive search [message #440735 is a reply to message #440718] Tue, 26 January 2010 21:44 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
hiswapna wrote on Tue, 26 January 2010 15:20

......
......
......
but when the procedure is called from JDBC adapater to connect to database the case insensitive search is not working. The server side is Webshphere (WID).
......



Try database the case insensitive search

Previous Topic: Problem with collections
Next Topic: Extract pl/sql Result into a text file without UTL_FILE pkg and spool
Goto Forum:
  


Current Time: Mon Sep 26 02:32:56 CDT 2016

Total time taken to generate the page: 0.08082 seconds