| FRM- 93652 [message #591314] |
Fri, 26 July 2013 05:28  |
 |
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  |
 |
Littlefoot
Messages: 21823
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
