Solution : https://service.sap.com/sap/support/notes/855943 (SAP Service marketplace login required)
Summary :
The SAP Note addresses the ORA-01756 error, which arises when a text string in an SEM Layout, using inverted commas, leads to a SQL failure in Oracle databases. This specific error surfaces when the substitution hint for literals is used. To resolve this, SAP advises importing the latest DBSl patch. Versions affected include patch 12 for Series 700, patch 79 for Series 640, and patch 2099 for Series 46D, effectively addressing the database error by ensuring correct string termination and hint processing.
Key words :
%'%_hints oracle '&substitute literals&'fails, database error ora-01756 occurs, oracle error ora-01756, substitute literals, quoted string, properly terminated, terms literal, sem layout, inverted commas, application terminates
Related Notes :
| 921165 | MB5B: Improving the runtime using database hints |
| 921164 | MB51: Improving the runtime using database hints |
| 918992 | MB5B: Improvements/additions to Note 902157/4.70 |
| 918991 | MB51: Improvements/additions Note 902675/4.70 |
| 902675 | MB51: Database hints to improve runtime / 4.70 |
| 902157 | MB5B: Improving the runtime using database hints/4.70 |