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
Did you know?Explore Trending and Topic pages for more stories like this.
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)')
No comments posted yet

Your Answer:

Login to answer
324 Like 52 Dislike
Previous forums Next forums
Other forums

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page:

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings

Logging and nologging bulk insert
Hi,

oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash