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

ASP.NET Validation Event Cycle
Hi,
I have asp button as follow:

Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought a

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

Pre-Fill out a PHP form...??
This is for work actually (geek squad). We have to fill out this online php form at work over and ov

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

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Automatically Detect Phone Model for WAP Jar Deployment
Making a wap site is fairly simple, but I'd like to know if there's a way to make it so that the wap