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

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

Upload file!
Ok i have a form..
Code: <form name="form1" method="post" action=&quo

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc

simplexml_load_file and rss problem
Hi,

I have a problem parsing an rss feed using simplexml_load_file - this is strange as i hav

Creating a db with a query
Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

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

QuoteBlah blah

Blah blah

etc
but when i ech

Print 'a' to 'z' via for loop
A very simple problem..
How Can I print a to z NOT a to y ?
It is a part of a code where
<