Skip to Content
0
Nov 12, 2013 at 10:17 AM

Sql error 1732 performing UPD on table PROGDIR

235 Views

Hello

It's about a tricky problem I get with an undocumented Oracle parameter

I get that error on a Unix box with Oracle 11.2.0.3.7 SBP 2013-09

When accessing to any table through SE16 I get a dump:

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 07.11.2013 14:01:45

UPDATE "PROGDIR" SET "RSTAT"=:A0 , "UNAM"=:A1 , "CNAM"=:A2 , "EDTX"=:A3 , "RLOAD"=:A4 ,

"OCCURS"=:A5\ [dbsc.c#2316],

"SUBC"=:A6 WHERE "NAME"=:A7 AND "STATE"=:A8 ; [dbsc.c#2318]

***LOG BY4=> sql error 1732 performing UPD on table PROGDIR

No error were reported at Oracle level.

It took a while before I discover that this was caused by parameter _simple_view_merging wrongly set to TRUE.

I did test this on a Windows system with Oracle 11.2.0.3 Bundle patch 22.

That time _simple_view_merging had to be set to FALSE to get the same Dump.

The thing is that I do not understand how that parameter can cause that problem has far as no IOTs are reported on my DB.

SELECT count(*) FROM DBA_INDEXES WHERE INDEX_TYPE = 'IOT - TOP' AND OWNER like 'SAP%';

COUNT(*)

0

I will be pleased to understand the root cause of that problem.

Anyway I think it is a good thing to know, that's why I did post this message.

Best regards

1915485 - Wrong results on Oracle Index Organized Table (IOT's)

A query involving IOT and secondary IOT indexes returns wrong results with the fix for bug 13705338 applied.

SELECT count(*) FROM DBA_INDEXES WHERE INDEX_TYPE = 'IOT - TOP' AND OWNER like 'SAP%';

COUNT(*)

0

If you see that your SAP user having a count > 0 then IOT's are created and you are affected by this bug.
If not, you don't need to apply the mentioned patch below.

1431798 - Oracle 11.2.0: Database Parameter Settings

September 30, 2013 => adjusted _simple_view_merging

September 19, 2013 => added _simple_view_merging = false for 11.2.0.3

_simple_view_merging FALSE (Note 1915485 - only whith IOT's)

UNIX SXD 11203x_date ( 2012 05 <= date <= 2013 10 )

WIN 11.2.0.3.nP ( 6 <= n <= 26 )