Skip to Content
0
Oct 31, 2005 at 05:32 PM

Native SQL buffering

29 Views

Hi We are doing some native sql in EXEC SQL ENDEXEC statments to get information from a non SAP source to import into SAP.

Problem is it seems to be buffered in some way. After deleting a record from the oracle windows client and rerunning the ABAP program it picks up data that was just deleted. Is there anyway to select without using any buffers or cache that oracle might be using?

Also a native delete seems to not work. Do we need to do a exec sql. commit work. endexec. ?

Thanks in advance,

Nigel