TIME_OUT in SAP when accessing external Oracle table thru native SQL

[Former Member]

Hi,

I have a problem in one of my native SQL statement. It takes a long time accessing the table considering that the number of records to be retrieved is only small.

Something happened on the Oracle system. But, stilll to be confirmed. Before, there wasn't any issue. Looking further, I found that when the value in the where clause equated is a literal (meaning the value is not declared in DATA or CONSTANTS in the ABAP Program)

Example

1.

EXEC.

....

WHERE FIELD = '1'

ENDEXEC.

instead of

2.

CONSTANTS: c_1 value '1'.

EXEC.

....

WHERE FIELD = c_1

ENDEXEC.

i found that when the way of coding is same as Example 1, a time-out error occurs. But when in Example 2, no issue.

Can someone explain this? is their something that could affect SAP with respect to Oracle configuration?

Thanks!

[Former Member]

Hi,

I have a problem in one of my native SQL statement. It takes a long time accessing the table considering that the number of records to be retrieved is only small.

Something happened on the Oracle system. But, stilll to be confirmed. Before, there wasn't any issue. Looking further, I found that when the value in the where clause equated is a literal (meaning the value is not declared in DATA or CONSTANTS in the ABAP Program)

Example

1.

EXEC.

....

WHERE FIELD = '1'

ENDEXEC.

instead of

2.

CONSTANTS: c_1 value '1'.

EXEC.

....

WHERE FIELD = c_1

ENDEXEC.

i found that when the way of coding is same as Example 1, a time-out error occurs. But when in Example 2, no issue.

Can someone explain this? is their something that could affect SAP with respect to Oracle configuration?

Thanks!

[Former Member]

I wonder if you could share the outline of your code to access an external oracle database. I've just been given the assignment to do just that, but don't know where to start.

thx,

Mike DeGuire