Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert new row into table via SQL*Developer - characters are transposed

836561May 14 2017 — edited May 14 2017

I'm using 4.2.0.17 of SQL*Developer.

When I try to insert a new row into a table (choosing the table from the left-hand menu, go to the data-tab and click the green plus), when I start to type into a cell (a column value), after the first character I type the cursor jumps back to the start of the field, so that the next character I type is to the left of the first. Thereafter character enter as normal  Eg.  If I try to type in 123  the value that appears is 231.

This happens both on the Windows and the Mac versions of 4.2.0.

Is this fixed in any upcoming release?

Comments

Christian Berg-0racle

You add this to the LSQL in the Advanced tab of an analysis. Prefix field.

SET VARIABLE DISABLE_CACHE_HIT=...

Or simply take it from John's blog: Oracle Business Intelligence OBIEE 101: OBIEE the "developersprompt"

Gopi Mannava

What about for the users when they logged in everytime.

Saresh-Oracle

Hi,

Please check the below notes:

  • OBIEE 11g - How To Disable Cache for a Single Report ? (Doc ID 2085805.1)
  • How To Temporarily disable Caching or Change LogLevel For A Specific Request (Doc ID 1272485.1)
  • How To Prevent Caching In OBIEE? (Doc ID 1955926.1)

Thanks,

Sareesh

Christian Berg-0racle

Put it into an init block in the RPD

Gopi Mannava

Thank Sareesh. I will look in to it.

Gopi Mannava

Did the same way Berg but no luck.The variables are appending automatically.

Gopi Mannava

Hi Sareesh,

The document you sent won't work for users. We are looking for user level.

Thanks,

Gopi.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 11 2017
Added on May 14 2017
1 comment
258 views