PL/SQL: ORA-00947: not enough values error message

Posted on 16th Feb 2014 07:03 pm by admin

Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing following insert statement. I am new to Oracle SPs, so could someone help me to solve the issue.

insert into estimate (ID, mID, mValue) values('select (case when pm.ID is null then 10
else pm.ID
end) ID, m1.mID,(case when mValue < 1 and m1.mID in( 1,7)
then mValue*100
else mValue
end) mValue from
scott.METRIC m1 left outer join
scott.PROJECTMETRIC pm on m1.mID = pm.ID and pm.ID = 10)')

Your Answer:

Login to answer

Other forums

"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

split values
I have values that are returned to me in this format:

name=>test,age=>49

gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s