[16.0.53] Script execution aborts in the middle

Toad for Oracle - Beta
1

When trying to execute a SQL script with F5, the process terminates in the middle without an error message.
The point at which the abort occurs is different for each attempt.

The SQL Spool file show this, after the last susccesfull command:

----------------------------------
-- Session: SP_TEMPLATE@ORADEV1
-- Timestamp: 10:21:31.517
begin
  sys.dbms_output.get_lines(:LINES, :NUMLINES);
end;
:LINES(VARCHAR[1000],)=<PL/SQL TABLE[100]> 
:NUMLINES(INTEGER,)=0

----------------------------------
-- Session: SP_TEMPLATE@ORADEV1
-- Timestamp: 10:21:31.579
begin :id := sys.dbms_transaction.local_transaction_id; end;
:id(VARCHAR[0],OUT)=<NULL>

----------------------------------
-- Timestamp: 10:21:31.579
Disconnect: SP_TEMPLATE@ORADEV1

Any ideas?

2

Is this 32 or 64 bit? Are you getting close to being out of memory?

Judging by the output I see above, I don't think this is the problem, but you could try decreasing these values just in case. Set Max Line Size just slightly longer than the longest line of output that you expect, and lines per fetch can be anything 1 or greater (setting it low means more calls to fetch the output, but requiring less memory to do so)

image
image789×486 29.2 KB

Can you get a spool sql for the entire script? I feel like there is more to see.

3

I'm using the 64 bit Application / Oracle-Driver. I don't think it's a memory issue. There are 6 GB of RAM configured in the VM and TOAD is the only application I use in it.

Unfortunately, I no longer have the output of the spool window. However, I did not notice anything unusual when looking through it.
I had then restarted Toad and then the script ran without problems, so I can not currently reproduce the error.

I had the same problem once in the past. But it occurs very rarely.