Toad World® Forums

Toad for Oracle 11.5 - run script

I used to be able to run a script in 9.7.2 such as

exec UBP.programming_com_tasks.add_prison (‘Meherrin River Regional Jail’,
‘Meherrin River Regional Jail’,
‘30-aug-2012’,
‘Meherrin River Regional Jail’,
921208,
‘9000 Boydton Plank Road’,
‘Alberta’,
‘VA’,
23831,
‘15000’,
‘150000’,
‘921208’,
‘921208’,
188,
‘Chesterfield’);

but since upgrading to 11.5, I get

ORA-06550: line 1, column 98:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

( - + case mod new not null

continue avg count current exists max min prior sql stddev

Note: if I put it on one line then it works, but it’s harder to validate.