OraFAQ Forum: Forms » query is not executing in forms side

Home » Developer & Programmer » Forms » query is not executing in forms side

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query is not executing in forms side [message #146980]

Tue, 15 November 2005 01:09

supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad

Member

Hi all,

I am getting problem with one query having nvarchar2 field...

my query is

select charge from table_name where group_id=l_grp_id;

data types for these fields are

charge number(16, Cool

group_id nvarchar2(20)

and the variable
" l_grp_id " is declared as table_name%type

and the data in the table is

group_id charge
---------------------------
95ID 100
aaID 200

and some symbols like inverse of "?" are present in the table.
may be the table has other language data (nvarchar2)

this query working fine in database side.

but when i use the same query in forms side i am getting
no data found error.

(1) Is there any other way to ignore those lines having symbols.
(2) Any parameters i need to set in forms?

Thank u
supriya

Report message to a moderator

Re: query is not executing in forms side [message #147104 is a reply to message #146980]

Tue, 15 November 2005 16:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you tried the same as that suggested previously in http://www.orafaq.com/forum/m/144589/67467/?srch=nvarchar2#msg_144589?

Do you have the same NLS_LANG setting for both your Forms Builder and Database? I'd GUESS that the Forms Builder is not handling the language when it compiles and generates. Search this forum for 'nls_lang' and 'nls_language' (I can't remember which is which, I always have to read the doco.) The database setting can be found through the SQL*Plus interface and the Forms setting is in the register (I assume you are developing under Windows).

David

Report message to a moderator

Previous Topic:	Returning to different block
Next Topic:	FORMS 6I - HOST NOT WORKING IN WIN XP (URGENT)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:59:22 CDT 2024