Archive : Oracle

Have you ever got this error in your oracle form ? FRM-40654: Record has been updated by another user. Re-query to see. The case that i had was i changed the query of 1 database block dynamically use set_block_property(‘BLOCK1′,Query_Data_Source_Name,’TABLE_X’). This BLOCK1 previously assign to TABLE_A. TABLE_X and TABLE_A has same fields structure. As summary, my form blocks [...]

Sometimes if you used TOAD as your user interface to connect to Oracle Database, you might face this kind of problem : Your arrow keys; Up and Down key, Left and Right keys, Backspace and some other keys doesn’t work in TOAD. Yea i know, its really annoying isn’t it? But no worries, with this simple steps, your issue will be solve. 1. Close your TOAD first 2. Go to your temp Quest Software [...]

This evening, i received another CSR that i need to follow up as Oracle IT support. This time is related to the Oracle BI Discoverer report. When the user tried to open one of the workbook they have in the database, it give them this error message: “Join configuration cannot be resolved. Reason: more than 1 of the detail folders uses non-aggregated items. Attempt to open workbook failed.” Ups [...]