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

A Few Questions
Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcu

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

Google Wave
So... has anyone used it yet? Is it any good?

http://wave.google.com/help/wave/about.html#vid

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Inter Company -- Resources Related Billing (Services Industry)
Hello,

My company has a scenario where:
Company A bills Company C for INTER (cross

undefined offset help
Hi All,

I kept getting undefined offset PHP notice for a simple for loop. For eg
$va = arr

How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh