FRM- 93652 [message #591314] |
Fri, 26 July 2013 05:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/87624576305926b1e6812638c3471b7b?s=64&d=mm&r=g) |
himanshusinghmbd
Messages: 15 Registered: July 2013 Location: GURGAON
|
Junior Member |
|
|
BEGIN go_block ('det');
SET_BLOCK_PROPERTY('DET',DEFAULT_WHERE,'PARTYCODE=:DISP_PARTY_CODE');
CLEAR_BLOCK;
execute_query;
first_record;
END;
when i am writing this code in oracle form builder 11g, i am geting error frm- 93652 The runtime process has terminated abnormally.
Contact your system administrator.
after removing SET_BLOCK_PROPERTY its running properly, but my task is not happening.
i am working on windows 7 Professional 32 bit
Can anyone help...
|
|
|
|
|
|
Re: FRM- 93652 [message #591323 is a reply to message #591321] |
Fri, 26 July 2013 06:29 ![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) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
... which means that no records satisfy that WHERE condition.
Display it (WHERE condition, I mean) on the screen so that you'd know what's going on. Do that by creating a variable which will hold the DEFAULT_WHERE clause, or check what GET_BLOCK_PROPERTY returns for DEFAULT_WHERE or even LAST_QUERY.
[EDIT] OK, so you fixed it. Great!
[Updated on: Fri, 26 July 2013 06:30] Report message to a moderator
|
|
|
|
Re: FRM- 93652 [message #591337 is a reply to message #591325] |
Fri, 26 July 2013 08:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
himanshusinghmbd wrote on Fri, 26 July 2013 07:39YES...
NOW...ITS WORKING.
That's because partycode is a VARCHAR2, not a number, as you failed to mention.
|
|
|