forms execute_query [message #503381] |
Fri, 15 April 2011 02:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
I am using forms 10g.
After EXECUTE_QUERY, i am validating records. Only 50% of records getting validated. Again if i tried only 50% of records validating out of balance. Pl help me.
|
|
|
|
|
|
Re: forms execute_query [message #503393 is a reply to message #503391] |
Fri, 15 April 2011 04:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
hi,
trigger is when_button_pressed.
If 50 records fetched then all the 50 records to vlaidated.
but it is validating only 25 records, and if again i try then another 13 records getting validated.
|
|
|
Re: forms execute_query [message #503396 is a reply to message #503393] |
Fri, 15 April 2011 04:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I would have thought your code would infinite loop personally.
There's nothing in the loop to make it change records (like next_Record) so it should just stay on the first one forever.
Are you sure that's the complete code?
|
|
|
Re: forms execute_query [message #503402 is a reply to message #503396] |
Fri, 15 April 2011 05:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
No it is part of code, i came to know in between the other code i had used DOWN, hence it was moved 3 record. It was my mistake. Thanks for sparing much time for me.
|
|
|