one error I find is, you are inserting 'null' into matric_value_id which has
not null constraint.
that may be the real issue.
regards
Gopa
On Jan 18, 2011 11:31 PM, "Shawn Hall" <shawnrh...@gmail.com> wrote:
Good morning,
I was hoping someone might have another set of eyes on this as to why its
not working or have an idea as to what I'm doing wrong.
SQL> desc rgnc_metric_value
Name Null? Type
----------------------------------------- --------
----------------------------
METRIC_VALUE_ID NOT NULL NUMBER(38)
METRIC_ID NUMBER
METRIC_VALUE VARCHAR2(2000)
METRIC_NAME VARCHAR2(64)
UNIT VARCHAR2(100)
BEGIN_TIME DATE
END_TIME DATE
MINVAL NUMBER
MAXVAL NUMBER
AVERAGE NUMBER
STANDARD_DEVIATION NUMBER
DB_ID NUMBER
SQL> desc target_metric_temp
Name Null? Type
----------------------------------------- --------
----------------------------
METRIC_ID NOT NULL NUMBER
METRIC_NAME NOT NULL VARCHAR2(192)
METRIC_UNIT NOT NULL VARCHAR2(192)
BEGIN_TIME NOT NULL DATE
END_TIME NOT NULL DATE
MINVAL NOT NULL NUMBER
MAXVAL NOT NULL NUMBER
AVERAGE NOT NULL NUMBER
STANDARD_DEVIATION NOT NULL NUMBER
DB_ID CHAR(3)
SQL>
SQL> MERGE INTO rgnc_metric_value x
USING target_metric_temp y
2 3 ON (x.metric_id = y.metric_id)
4 WHEN NOT MATCHED THEN
5 insert (metric_value_id, metric_id, metric_name, unit, begin_time,
end_time, minval, maxval, average, standard_deviation, db_id)
6 values (NULL, y.metric_id, y.metric_name, y.unit, y.begin_time,
y.end_time, y.minval, y.maxval, y.average, y.standard_deviation, y.db_id);
values (NULL, y.metric_id, y.metric_name, y.unit, y.begin_time, y.end_time,
y.minval, y.maxval, y.average, y.standard_deviation, y.db_id)
*
ERROR at line 6:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_Y'
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
