Hi Shawn, After looking your query, the error because of NULL value. You remove the NULL and try. this should work.
Thanks, Praveen Namdeo Emirates Group IT On Tue, Jan 18, 2011 at 10:00 AM, 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
