PL/SQL: ORA-00928: missing SELECT keyword

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

When i execute i am getting abobe exception;

instead of  'EX' in DOC_TYPE if i put other value its not giving any error;Is it a bug in 10.2.0.1 version?
LVL 20
chaitu chaituAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mohammedfCommented:
it seems it is a bug !!!
are u using SQL+ or for builder ?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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;

Open in new window

0
chaitu chaituAuthor Commented:
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','','','');;
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have no idea, is this really only when you have 'EX' as value, any other string works?
0
SJT2003ACommented:
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 :)
0
schwertnerCommented:
If you do not provide values for some columns you do not need to mention them.

insert into OUTSTANDING_EMP_IDS(DOC_TYPE )
            VALUES ('EX');

The only valid test bed is SQL*Plus.
Other GUIs like SQLDeveloper, PL/SQL Developer, TOAD
have more then enough bugs.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.