Skip to Content
avatar image
Former Member

TIME_OUT when accessing Oracle table from SAP using native SQL

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. Looking further at the issue, it seems 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?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 16, 2009 at 01:15 PM

    Repetitively asking the same question again and again is against the forum rules.

    Please post an explain of the SQL statement on the remote machine.

    Markus

    Add comment
    10|10000 characters needed characters exceeded