SAP native sql and oracle

vladimir_culic — Mon, 30 Jan 2017 13:08:56 GMT

Hi,

I have strange problem with native SQL and calling of stored procedures. SAP is running on MSSQL Server and we are in need to update another database which is on oracle. Everything was fine until we upgrade SAP from EHP 6 to EHP 7.

Stored procedures on oracle server has 3 parameters and its purpose is to maintain table on oracle. Parameters:

Action CHAR2(SAP) VARCHAR2(Oracle)
ID INT4(SAP) NUMBER(Oracle)
Name CHAR50(SAP) VARCHAR2(Oracle)

Action can have values I, U, D.

Problem is that values received by procedure are empty for values I wrote. When I send IU, II, IF, IR parameter value inside procedure is I(first letter). ID is correct and name is empty to.

EXEC SQL.
   execute procedure change_tab_values( IN :l_action, IN :l_id, IN :l_name)
ENDEXEC.

I also tried with ADBC approach.

Can someone help with this problem?

Re: SAP native sql and oracle

janos_mucsi-besze — Tue, 31 Jan 2017 11:59:56 GMT

Hi Vladimir, ABAP Native SQL Statement are not 'translated' by the Database Shared Library (DBSL), these are just executed. This is why SAP recommends and suggests to use OPEN SQL Statements, which is Database-Independent.
I am affraid, you have to rewrite the Native SQL Statement and adapt this to Oracle.

Regards,

János

Question Re: SAP native sql and oracle in Technology Q&A

SAP native sql and oracle

Re: SAP native sql and oracle