PL/SQL: ORA-00928: missing SELECT keyword

it seems it is a bug !!!
are u using SQL+ or for builder ?

how do you run this code?

what about this:

insert into OUTSTANDING_EMP_IDS(DOC_TYPE,REFID_1,REFID_2,REFID_3)
            SELECT 'EX','','','' FROM DUAL;

Select allOpen in new window

when i write like this its inserting in pl/sql developer.
insert into OUTSTANDING_EMP_IDS(DOC_TYPE,REFID_1,REFID_2,REFID_3)
            SELECT 'EX','','','' FROM DUAL;
 
but below one is giving problem in pl/sql developer.;through sql plus its inserting;i think its problem with the pl/sql developer.what was the reason?i am using  7.0.3 version.

insert into OUTSTANDING_EMP_IDS(DOC_TYPE,REFID_1,REFID_2,REFID_3)
           values('EX','','','');;

I have no idea, is this really only when you have 'EX' as value, any other string works?

Try giving null instead of just a couple of single quotes for REFID fields. .

Try like:

insert into OUTSTANDING_EMP_IDS(DOC_TYPE,REFID_1,REFID_2,REFID_3)
            VALUES ('EX',null, null, null');

Here I assume you want to store null for REFID fields and they are NULLABLE.
Check it out. Good luck :)