Data type is mismatch, please check both the columns has been following the exact data type and the size,rgnc_metric_value can have size highter not in the vice versa
regards jomesh On Tue, Jan 18, 2011 at 11:30 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 -- jomesh joseph veliyath -- 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
