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

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

Scene graph using Direct3D?
There are several C++ scene graph based packages available for OpenGl, like say OSG,

http://w

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Re-Order by ID Number
I have a cms set up for inputting an image, thumb, title, pdf, and eps. When input the database ass

php email checker
I am having alot of trouble finding info on how to do these email things. I need to do the following

problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:

Code: $query = &quo

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<