inconsistent datatypes: expected DATE got NUMBERORA-06512
954056Aug 6 2012 — edited Aug 24 2012Hi,
Sporadically getting this exception.I am using .Net 2.0 with ODP .net 2.112.1.0 . Oracle version is 11g . I have used BindByName = true.
declare
bv_EFFECTIVEFROM date := to_date('2008/05/30 02:04:21', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c141 date := to_date('2008/05/30 02:04:32', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c22 date := to_date('2008/05/30 02:04:20', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c33 date := to_date('2008/05/30 02:04:28', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c36 date := to_date('2008/05/30 02:04:29', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c48 date := to_date('2008/05/30 02:04:30', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c50 date := to_date('2008/05/30 02:04:31', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVEFROM_c56 date := to_date('2008/05/30 02:04:22', 'YYYY/MM/DD HH:MI:SS');
bv_EFFECTIVETO date := null;
bv_ENTITYTYPE number := 1;
bv_FileNameID number := 153;
bv_MarketDateDeleted date := null;
bv_MarketDateModified date := to_date('2012/07/27 12:00:00', 'YYYY/MM/DD HH:MI:SS');
bv_MarketDateVerified date := to_date('2012/07/27 12:00:00', 'YYYY/MM/DD HH:MI:SS');
bv_MASTERFILESETFILEID number := 1;
bv_MASTERFILESETFILEID_c187 number := 0;
bv_RELATEDFROMENTITYID number := 4295903973;
bv_RELATEDFROMENTITYTYPE varchar2(12) := 'Organization';
bv_RELATEDTOENTITYID number := 8590944794;
bv_RELATEDTOENTITYID_c100 number := 8590945304;
bv_RELATEDTOENTITYID_c101 number := 8590945305;
bv_RELATEDTOENTITYID_c102 number := 8590945312;
bv_RELATEDTOENTITYID_c103 number := 8590945316;
bv_RELATEDTOENTITYID_c104 number := 8590945318;
bv_RELATEDTOENTITYID_c105 number := 8590945320;
bv_RELATEDTOENTITYID_c106 number := 8590945337;
bv_RELATEDTOENTITYID_c107 number := 8590945347;
bv_RELATEDTOENTITYID_c108 number := 8590945350;
bv_RELATEDTOENTITYID_c109 number := 8590945357;
bv_RELATEDTOENTITYID_c110 number := 8590945359;
bv_RELATEDTOENTITYID_c23 number := 8590944822;
bv_RELATEDTOENTITYID_c24 number := 8590944824;
bv_RELATEDTOENTITYID_c25 number := 8590944876;
bv_RELATEDTOENTITYID_c26 number := 8590944881;
bv_RELATEDTOENTITYID_c27 number := 8590944954;
bv_RELATEDTOENTITYID_c28 number := 8590944956;
bv_RELATEDTOENTITYID_c29 number := 8590944960;
bv_RELATEDTOENTITYID_c30 number := 8590944964;
bv_RELATEDTOENTITYID_c31 number := 8590944968;
bv_RELATEDTOENTITYID_c32 number := 8590944973;
bv_RELATEDTOENTITYTYPE varchar2(10) := 'Instrument';
bv_RELATIONSHIPTYPECODE varchar2(10) := 'IsIssuerOf';
bv_SOURCE number := 3;
bv_SOURCEENTITYID nvarchar2(10) := '4295903973';
bv_StatusCode number := 96;
bv_StatusLockKey nvarchar2(1) := null;
begin
begin
begin
begin
begin
insert into oa.organization_isissuerof (effectivefrom, effectiveto, entitytype, masterfilesetfileid, relatedfromentityid, relatedfromentitytype, relatedtoentityid, relatedtoentitytype, relationshiptypecode, source, sourceentityid) values (bv_effectivefrom, bv_effectiveto, bv_entitytype, bv_masterfilesetfileid, bv_relatedfromentityid, bv_relatedfromentitytype, bv_relatedtoentityid, bv_relatedtoentitytype, bv_relationshiptypecode, bv_source, bv_sourceentityid) ;
end;
end;
begin
update fpf.ascollectedsourceentityids set filenameid = bv_filenameid , marketdatedeleted = bv_marketdatedeleted , marketdatemodified = bv_marketdatemodified , marketdateverified = bv_marketdateverified , statuscode = bv_statuscode , statusdate = sysdate , statuslockkey = bv_statuslockkey where source = bv_source and entitytype = bv_entitytype and masterfilesetfileid = bv_masterfilesetfileid_c187 and sourceentityid = bv_sourceentityid;
end;
commit work;
exception when others then begin
rollback;
raise;
end;
end;
end;
end;
Regards,
Rakesh