OraFAQ Forum: Forms » Same Query Gives different result in Same database

Home » Developer & Programmer » Forms » Same Query Gives different result in Same database

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

Same Query Gives different result in Same database [message #221280]

Mon, 26 February 2007 03:06

parthaspaul
Messages: 9
Registered: December 2006
Location: KOLKATA

Junior Member

Hi All!

I've used the following code in my form :

select count(*) into cnt from md_person_dept a, mm_login_user b
where a.PERSON_CODE =b.person_code and user_id=:global.user_id
and a.txt_project_id=b.txt_project_id
and a.txt_project_id=:global.g_proj_code_ca_bkup_presla
;

----------------
This piece of code is in new-form-instance trigger.
When the form is running it fetches into cnt 0 value whether I excute the query in TOAD it shows 54 .

The most interesting thing is that when I write the query as
select count(*) into cnt from md_person_dept a, mm_login_user b
where a.PERSON_CODE =b.person_code
and a.txt_project_id=b.txt_project_id
and a.txt_project_id=:global.g_proj_code_ca_bkup_presla
and user_id=:global.user_id
;

Then in form runtime and TOAD both it fetches 54 count.

Please tell me why it happens??

Urgent ly please.

Thanks.

Partha Sarathi Paul.

Report message to a moderator