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

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

PHP FTP Can't upload Big FIles
Anyone had any success using FTP to upload a file say 90m?

im using ftp_put and it returns fa

need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo