Timeline for Wrong query results on column ORA_ROWSCN with bind variables and NVL (Oracle 12c)
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 2, 2018 at 7:49 | vote | accept | user1366204 | ||
| Jul 23, 2018 at 7:39 | answer | added | Balazs Papp | timeline score: 0 | |
| Jul 23, 2018 at 6:55 | comment | added | user1366204 | Thanks for your interest. I updated the text accordingly. | |
| Jul 23, 2018 at 6:53 | history | edited | user1366204 | CC BY-SA 4.0 |
I updated the question with the type of column RID, the patchset version, and the execution plans.
|
| Jul 23, 2018 at 3:28 | comment | added | Gary | The query with the bind variable may be using a different execution plan from the one with the hardcoded value. Posting the plans may give a clue. | |
| Jul 20, 2018 at 20:16 | comment | added | Mark Stewart |
What's the definition of my_table? Specifically the data type of the RID column?
|
|
| Jul 20, 2018 at 13:46 | comment | added | Jack Douglas |
odd. What is your 12c patchset? (please post the result of select * from v$version;)
|
|
| Jul 20, 2018 at 13:23 | review | First posts | |||
| Jul 20, 2018 at 14:27 | |||||
| Jul 20, 2018 at 13:22 | history | asked | user1366204 | CC BY-SA 4.0 |