ORA-00911 using semicolon to separate select statements

MK023

Member
Hi there

I've been using PLSQL on one pc, and I normally use a semicolon to separate my select statements, like below:

select * from fcislob.unitholderdealtbl;

SELECT * FROM FCISLOB.SYSPARAMTBL;

So whenever I pressed F8 to run a select statement, it would run the section between semicolons (where my cursor happened to be).

Now, I've been moved to an new pc... but when I try to do the exact same I've been doing for month on my old pc, it returns the ORA-00911 error. If I remove the semicolon and manually highlight the select statement I want to run, it works. However that is such a pain. I'm thinking it's a setting somewhere? Please can someone help.

Possibly related to this, I
 
Back
Top