Re: PL/SQL vs. SQL*Plus remote query/insert problem

Taking a shot in the dark,

When you enclose the sql fragments between Begin & End you are creating an enclosed transaction that starts with Begin but doesn't commit until you post the commit statement or reach the End statement. In effect your transaction has two insert statements

SQL+ is commiting after each of the insert fragments.

Try posting a COMIT after each insert.

Let me know if you fix the problem.

--
Michael Hartley
Help the Whales.