RE: Strange issue with inserting varchar2()
[email protected] ("Fennell, Brian") Fri, 28 May 2021 00:39:43 +0000
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <MN2PR14MB329467C5BA99D18EC93253B7A2229@MN2PR14MB3294.namprd14.prod.outlook.com> |
SGVyZSBhcmUgYSBmZXcgYXJ0aWNsZXMgaWYgeW91IHJlYWxseSB3YW50IHRvIGRpZyBpbg0KDQpo dHRwczovL3N0YWNrb3ZlcmZsb3cuY29tL3F1ZXN0aW9ucy81MjkwMTgyL2hvdy1tYW55LWJ5dGVz LWRvZXMtb25lLXVuaWNvZGUtY2hhcmFjdGVyLXRha2UNCg0KaHR0cHM6Ly9kb2NzLm9yYWNsZS5j b20vZGF0YWJhc2UvMTIxL05MU1BHL2NoMmNoYXJzZXQuaHRtI05MU1BHMTAzNw0KDQpodHRwczov L21ldGFjcGFuLm9yZy9wb2QvVGV4dDo6SWNvbnYNCg0KaHR0cHM6Ly9tZXRhY3Bhbi5vcmcvcG9k L2Rpc3RyaWJ1dGlvbi9wZXJsL3BvZC9wZXJsdW5pZmFxLnBvZA0KDQpodHRwczovL21ldGFjcGFu Lm9yZy9wb2QvZGlzdHJpYnV0aW9uL3BlcmwvcG9kL3Blcmx1bmlmYXEucG9kDQoNCg0KDQotLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogRmVubmVsbCwgQnJpYW4gPGZlbm5lbGxiQHJh ZGlhbC5jb20+DQpTZW50OiBUaHVyc2RheSwgTWF5IDI3LCAyMDIxIDg6MTAgUE0NClRvOiBCcnVj ZSBKb2huc29uIDxqb2huc29uQFBoYXJtYWN5LkFyaXpvbmEuRURVPjsgZGJpIHVzZXJzIDxkYmkt dXNlcnNAcGVybC5vcmc+DQpTdWJqZWN0OiBbRVhURVJOQUxdIFJFOiBTdHJhbmdlIGlzc3VlIHdp dGggaW5zZXJ0aW5nIHZhcmNoYXIyKCkNCg0KVVRGLTggaGFzIGEgdmFyaWFibGUgbnVtYmVyIG9m IGJ5dGVzIHBlciBjaGFyYWN0ZXIuICBTb21lIGVuY29kaW5ncyBoYXZlIDEgYnl0ZSBwZXIgY2hh cmFjdGVyIGFsd2F5cy4gIFNvbWUgZW5jb2RpbmdzIGhhdmUgdHdvIGJ5dGVzIHBlciBjaGFyYWN0 ZXIgYWx3YXlzLg0KQXNzdW1pbmcgdGhhdCB0aGUgbnVtYmVyIG9mIGJ5dGVzIGlzIHRoZSBzYW1l IGFzIHRoZSBudW1iZXIgb2YgY2hhcmFjdGVycyBzb21ldGltZXMgbGVhZHMgdG8gd3JvbmcgYW5z d2Vycy4NCldoZW4geW91IGFyZSB1c2luZyBwZXJsIGFzIGEgY2xpZW50IHRvIG9yYWNsZSB5b3Ug bWF5IGhhdmUgY2hhcmFjdGVycyBpbiBtb3JlIHRoYW4gb25lIGVuY29kaW5nIHNvIHlvdSBoYXZl IHRvIGJlIHZlcnkgY2FyZWZ1bCB3aXRoIHRoZSBieXRlIGNvdW50IGFuZCBjaGFyYWN0ZXIgY291 bnQuDQpUaGUgcGVybCBsaWJyYXJpZXMgd2hpY2ggYWNjZXNzIE9yYWNsZSBkYXRhYmFzZSBhcmUg YnVpbHQgd2l0aCBhIHNwZWNpZmljIE9yYWNsZSBDIExpYnJhcnkgaW1wbGVtZW50YXRpb24sIGFu ZCB0aGUgcnVsZXMgZm9yIGNoYXJhY3RlciBlbmNvZGluZyBhbmQgY2hhcmFjdGVyIGJ5dGUgY291 bnQgYXJlIHNvbWV0aW1lcyBkaWZmZXJlbnQgZnJvbSBvbmUgdmVyc2lvbiB0byBhbm90aGVyLg0K SW4gYWRkaXRpb24gdGhlIHBlcmwgcnVsZXMgZm9yIGNoYXJhY3RlciBjb3VudGluZyBhbmQgYnl0 ZSBjb3VudGluZyBhcmUgZGlmZmVyZW50IGZvciBkaWZmZXJlbnQgdmVyc2lvbnMgb2YgcGVybC4N CkluIGFkZGl0aW9uIHRoZSBPcmFjbGUgRGF0YWJhc2UgaGFzIGl0cyBvd24gaWRlYSBvZiBjaGFy YWN0ZXIgZW5jb2RpbmcgYW5kIGJ5dGUgY291bnQuICBBbmQgdGhpcyBhbHNvIGNoYW5nZXMgd2l0 aCB2ZXJzaW9uLg0KU28geW91IGFyZSB0aHJlYWRpbmcgbW9yZSB0aGFuIG9uZSBuZWVkbGUgYXQg dGhlIHNhbWUgdGltZSAtIGl0IGNhbiBnZXQgKGFuZCB1c3VhbGx5IGRvZXMgZ2V0KSB2ZXJ5IGNv bXBsaWNhdGVkIHZlcnkgcXVpY2tseS4NClRoZSB1c3VhbCBzb2x1dGlvbiBpcyB0byB0cnkgdG8g Z2V0IGFsbCB0aGUgbGF5ZXJzIHRvIHVzZSB0aGUgc2FtZSBlbmNvZGluZyAoYW5kIHRoZXJlZm9y ZSB0aGUgc2FtZSBudW1iZXIgb2YgYnl0ZXMgcGVyIGNoYXJhY3RlcikuICBVVEYtOCAod2l0aCBV bmljb2RlIEludGVnZXIgdG8gQ2hhcmFjdGVyIE1hcHBpbmcgYW5kIFVURi04IEJ5dGUgRW5jb2Rp bmcgb2YgdGhlIGludGVnZXJzKSBmb3IgYWxsIGxheWVycyB1c3VhbGx5IHdvcmtzLCBidXQgaWYg eW91IGRvbid0IGhhdmUgY29udHJvbCBvdmVyIGFsbCB0aGUgbGF5ZXJzIHlvdSBtYXkgbm90IGJl IGFibGUgdG8gY2hvb3NlIHRoaXMuDQpBbm90aGVyIGNob2ljZSBpcyB0byBmaW5kIG91dCB3aGF0 IGNoYXJhY3RlciBlbmNvZGluZyB0aGUgZGF0YWJhc2UgaXMgdXNpbmcgYW5kIHRyeSB0byBjb25m aWd1cmUgYWxsIG90aGVyIGxheWVycyB0byB1c2UgdGhlIHNhbWUgZW5jb2RpbmcuDQpJdCBpcyBh bHNvIGhlbHBmdWwgdG8ga25vdyB0aGF0IHRoZSBFbmdsaXNoIGxldHRlcnMgQS1aIGFuZCBhLXog YW5kIHRoZSBkaWdpdHMgMC05IGFyZSBvZnRlbiBlbmNvZGVkIHRoZSBzYW1lIHdheSBmb3IgbWFu eSBkaWZmZXJlbnQgZW5jb2RpbmdzIHNvIHNvbWV0aW1lcyB5b3UgY2FuIGNoZWF0IGJ5IGZvcmNp bmcgYWxsIG9mIHlvdXIgZGF0YSB0byBiZSAicHVyZSA3IGJpdCBhc2NpaSIgYW5kIGhvcGluZyB0 aGF0IGFsbCB0aGUgbGF5ZXJzIHdpbGwgYmUgImNsb3NlIGVub3VnaCIuDQpUaGUgT1MgYWxzbyBt YXkgaGF2ZSBpdHMgb3duIHJ1bGVzIGFib3V0IGNoYXJhY3RlciBlbmNvZGluZyBzbyBldmVuIHRo ZSBzYW1lIHZlcnNpb24gb2YgcGVybCBvbiBXaW5kb3dzIGFuZCBMaW51eCBtYXkgaGF2ZSBkaWZm ZXJlbnQgZW5jb2RpbmcgcnVsZXMuDQoNClRoZSBsYXN0IHRpbWUgSSB0cmllZCB0byBmaWd1cmUg dGhpcyBvdXQgZm9yIGEgcmVhbCBsaWZlIGV4YW1wbGUgSSBzaW1wbHkgZ2F2ZSB1cCB0cnlpbmcg dG8gdW5kZXJzdGFuZCBpdCBhbmQgaGFkIHRvIHJvbGwgYmFjayB0aGUgdmVyc2lvbiBvZiBwZXJs IEFORCB0aGUgREJJIC8gREJEIGxpYnJhcmllcyAoYW5kIHRoZXJlZm9yZSB0aGUgdmVyc2lvbiBv ZiBPcmFjbGUgQyBDbGllbnQgTGlicmFyaWVzKSB0byBrbm93biB3b3JraW5nLg0KDQpUbyBiZSBh YnNvbHV0ZWx5IDEwMCBwZXJjZW50IHN1cmUgeW91IGdldCBpdCByaWdodCB5b3UgbmVlZCB0byB1 bmRlcnN0YW5kIHRoZSBPUywgcGVybCwgb3JhY2xlIGNsaWVudCBhbmQgb3JhY2xlIHNlcnZlciBy dWxlcyBpbnNpZGUgYW5kIG91dCAtIGFuZCBmcmFua2x5IHRoaXMgaXMgdmVyeSBoYXJkLg0KRXZl biBpZiB5b3UgdW5kZXJzdGFuZCBpdCBhbGwgc29tZSBsYXllciBtYXkgc2ltcGx5IG5vdCBiZSBh YmxlIHRvIGRvIHdoYXQgeW91IHdhbnQgaXQgdG8gZG8uDQoNCldoZW4gdGhlIHBlcmwgcHJvZ3Jh bW1pbmcgbGFuZ3VhZ2Ugd2FzIGZpcnN0IGNyZWF0ZWQgdGhlIGlkZWEgd2FzIHRoYXQgYSBjaGFy YWN0ZXIgd2FzIGEgYnl0ZSBhbmQgYSBieXRlIHdhcyBhIGNoYXJhY3RlciAtIHRoaW5ncyBoYXZl IGNoYW5nZXMgc2luY2UgdGhlbiAtIG1vcmUgdGhhbiBvbmNlLg0KVGhlIHNhbWUgaXMgdHJ1ZSBv ZiB0aGUgT3JhY2xlIERhdGFiYXNlIGFuZCBjbGllbnQgbGlicmFyaWVzIC0gKGFuZCBXaW5kb3dz IGFuZCBMaW51eCkgLSB0aGUgZ3Jvd2luZyBwYWlucyBsZWZ0IGEgbG90IG9mIHN0cmFuZ2UgYXJ0 aWZhY3RzIGJlaGluZCBpbiBhbGwuDQoNCkFub3RoZXIgdHJpY2sgaXMgbWFrZSBhbGwgYnVmZmVy cyA0IHRpbWVzIGFyZSBiaWcgYXMgeW91IHRoaW5rIHlvdSByZWFsbHkgbmVlZCB0aGVtIGFuZCB0 aGVuIGhhdmUgdGhlIGRhdGFiYXNlIGNvbmNhdCB0aGUgZGF0YSB0b2dldGhlciBvbiB0aGUgc2Vy dmVyIHNpZGUgLSBkbyBpbiB0aGUgZW5kIHlvdSBhcmUgb25seSB3b3JraW5nIHdpdGggb25lIGxh eWVyLg0KTGFzdCB0aW1lIEkgY2hlY2tlZCA0IGJ5dGVzIHBlciBjaGFyYWN0ZXIgd2FzIHRoZSB3 b3JzZSBjYXNlIHNjZW5hcmlvLiAgSXQgbWlnaHQgYmUgOCBieSBub3cuDQoNClRoZXJlIGFyZSBh bHNvICJsb3NzbGVzcyIgd2F5cyBvZiBlbmNvZGluZyAiaWxsZWdhbCBjaGFyYWN0ZXJzIiwgc3Vj aCBhcyBVVEYtOCBlbmNvZGUgZmlyc3QgdGhlbiBNaW1lIFEtRW5jb2RlIChxdW90ZWQgcHJpbnRh YmxlKSBvciB1c2luZyBYTUwgLyBYSFRNTCBlbnRpdGllcyBsaWtlIHRoaXMgLSAmIzEyNDsgb3Ig VVRGLTggZW5jb2RlIHRoZW4gcGVyY2VudC1lbmNvZGUuDQpUaGlzIGNhbiBiZSB1c2VkIHdvcmsg YXJvdW5kIHNwZWNpYWwgY2hhcmFjdGVycyB3aGVuIHlvdSBhcmUgZGVhbGluZyB3aXRoIG1vc3Rs eSBFbmdsaXNoIHdpdGggc29tZSBFdXJvcGVhbiBjaGFyYWN0ZXJzIGFuZCBhbiBlbmNvZGluZyB0 aGF0IGlzIGVpdGhlciA3LWJpdC1hc2NpaSBjb21wYXRpYmxlIG9yIGNhbiBlYXNpbHkgYmUgY29u dmVydGVkIHRvIGFuZCBmcm9tIChsb3NzbGVzc2x5KSA3LWJpdC1hc2NpaSAoc3VjaCBhcyBFQkNJ RElDIHdpdGggc29tZSBjcmVhdGl2aXR5KS4NCkFuZCB0aGVyZSBpcyBhbHdheXMgZ29vZCBvbGQg aGV4YWRlY2ltYWwuDQoNCkl0IGFsbCBkZXBlbmRzIG9uIHlvdXIgdXNlLWNhc2VzLCBob3cgbXVj aCBjb250cm9sIHlvdSBoYXZlIG92ZXIgeW91ciBlbnZpcm9ubWVudCBhbmQgaG93IG11Y2ggdGlt ZSB5b3UgY2FuIHNwZW5kIGJlaW5nIGNsZXZlci4NCg0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNz YWdlLS0tLS0NCkZyb206IEJydWNlIEpvaG5zb24gPGpvaG5zb25AUGhhcm1hY3kuQXJpem9uYS5F RFU+DQpTZW50OiBUaHVyc2RheSwgTWF5IDI3LCAyMDIxIDc6MzYgUE0NClRvOiBkYmkgdXNlcnMg PGRiaS11c2Vyc0BwZXJsLm9yZz4NClN1YmplY3Q6IFtFWFRFUk5BTF0gU3RyYW5nZSBpc3N1ZSB3 aXRoIGluc2VydGluZyB2YXJjaGFyMigpDQoNCkknbSB3b3JraW5nIG9uIGFuIGFwcCB0aGF0IHBy b2Nlc3NlcyAoYW1vbmcgb3RoZXIgdGhpbmcpIGxvbmcgc2VjdGlvbnMgb2YgdGV4dCwgYW5kIEni gJltIHJ1bm5pbmcgaW50byBvZGQgbXVsdGktYnl0ZSBjaGFyYWN0ZXJzIGluIHNvbWUgb2YgdGhl IGVudHJpZXMuDQoNClRoZSBjb2x1bW4gaW4gcXVlc3Rpb24gaXMgYSB2YXJjaGFyMig0MDAwKSBz byBJIGFtIHRydW5jYXRpbmcgdGhlIGlucHV0IHRvIDQwMDAgYnl0ZXMuDQoNCih2aWEgdXNlIOKA nGJ5dGVzOyAkc3RyaW5nPXN1YnN0cigkb3JpZywwLDQwMDApOyDigJ0gaW4gdGhlIHNlY3Rpb24g d2hlcmUgSSBhY3R1YWxseSB0cnVuY2F0ZSB0aGUgc3RyaW5nLikNCg0KV2hlbiBJIGRvIHRoZSBp bnNlcnQgSSBnZXQgYW4gIE9SQS0xMjg5OTogdmFsdWUgdG9vIGxhcmdlIGZvciBjb2x1bW4gIkFX QVJEIi4iUFJFQ0VQVF9OT01JTkFUSU9OUyIuIk9OQ09MT0dZX0NPTU1FTlRTIiAoYWN0dWFsOiA0 MDU0LCBtYXhpbXVtOiA0MDAwKSBlcnJvcg0KDQpXaGVuIEkgY2hlY2sgdGhlIGFjdHVhbCBsZW5n dGggb2YgdGhlIG9mZmVuZGluZyBzdHJpbmcgaW4gYnl0ZXMgb24gdGhlIHBlcmwgc2lkZSBpdCBp cyA0MDAwICpieXRlcyogbG9uZw0KDQpPcmlnaW5hbCBPbmNvbG9neSBjb21tZW50IGlzIDQ4MDQg Y2hhcnMgKDQ4MjQgYnl0ZXMpIGxvbmcgYW5kIHdoZW4gdHJ1bmNhdGVkIGluIGNoYXJhY3RlciBt b2RlIHRvIDQwMDAgY2hhcnMgaXTigJlzIDQwMTggYnl0ZXMgbG9uZywgd2hlbiB0cnVuY2F0ZWQg aW4gYnl0ZSBtb2RlLCBpdOKAmXMgNDAwMCBjaGFycyBhbmQgYnl0ZXMuDQoNCldoYXTigJlzIGNv bmZ1c2luZyBtZSBpcyB0aGF0IHRoZSBzaXplIG9mIHRoZSBzdHJpbmcgYmVpbmcgcmVwb3J0ZWQg Ynkgb3JhY2xlIGluIHRoZSBlcnJvciBkb2VzbuKAmXQgbWF0Y2ggYW55IG9mIHRoZSB2YWx1ZXMg dGhhdCBJIHNlZSBpbiBwZXJsLiBJ4oCZbSBub3Qgc3VyZSB0aGlzIGlzIGEgREJJIGlzc3VlIG9y IG5vdC4NCg0KLS0NCkJydWNlIEpvaG5zb24NClVuaXZlcnNpdHkgb2YgQXJpem9uYQ0KQ29sbGVn ZSBvZiBQaGFybWFjeQ0KSW5mb3JtYXRpb24gVGVjaG5vbG9neSBHcm91cA0KDQpJbnN0aXR1dGlv bnMgZG8gbm90IGhhdmUgb3BpbmlvbnMsIG1lcmVseSBjdXN0b21zDQoNCg0KDQoNClRoZSBpbmZv cm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBlbGVjdHJvbmljIG1haWwgdHJhbnNtaXNzaW9uIGlz IGludGVuZGVkIG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwgb3IgZW50aXR5IG5h bWVkIGluIHRoaXMgdHJhbnNtaXNzaW9uLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVj aXBpZW50IG9mIHRoaXMgdHJhbnNtaXNzaW9uLCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0 IGFueSBkaXNjbG9zdXJlLCBjb3B5aW5nIG9yIGRpc3RyaWJ1dGlvbiBvZiB0aGUgY29udGVudHMg b2YgdGhpcyB0cmFuc21pc3Npb24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZCBhbmQgdGhhdCB5b3Ug c2hvdWxkIGRlbGV0ZSB0aGUgY29udGVudHMgb2YgdGhpcyB0cmFuc21pc3Npb24gZnJvbSB5b3Vy IHN5c3RlbSBpbW1lZGlhdGVseS4gQW55IGNvbW1lbnRzIG9yIHN0YXRlbWVudHMgY29udGFpbmVk IGluIHRoaXMgdHJhbnNtaXNzaW9uIGRvIG5vdCBuZWNlc3NhcmlseSByZWZsZWN0IHRoZSB2aWV3 cyBvciBwb3NpdGlvbiBvZiBSYWRpYWwgb3IgaXRzIHN1YnNpZGlhcmllcyBhbmQvb3IgYWZmaWxp YXRlcy4NCg0KDQoNCg0KDQpUaGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZWxlY3Ry b25pYyBtYWlsIHRyYW5zbWlzc2lvbiBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNlIG9mIHRo ZSBpbmRpdmlkdWFsIG9yIGVudGl0eSBuYW1lZCBpbiB0aGlzIHRyYW5zbWlzc2lvbi4gSWYgeW91 IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCBvZiB0aGlzIHRyYW5zbWlzc2lvbiwgeW91 IGFyZSBoZXJlYnkgbm90aWZpZWQgdGhhdCBhbnkgZGlzY2xvc3VyZSwgY29weWluZyBvciBkaXN0 cmlidXRpb24gb2YgdGhlIGNvbnRlbnRzIG9mIHRoaXMgdHJhbnNtaXNzaW9uIGlzIHN0cmljdGx5 IHByb2hpYml0ZWQgYW5kIHRoYXQgeW91IHNob3VsZCBkZWxldGUgdGhlIGNvbnRlbnRzIG9mIHRo aXMgdHJhbnNtaXNzaW9uIGZyb20geW91ciBzeXN0ZW0gaW1tZWRpYXRlbHkuIEFueSBjb21tZW50 cyBvciBzdGF0ZW1lbnRzIGNvbnRhaW5lZCBpbiB0aGlzIHRyYW5zbWlzc2lvbiBkbyBub3QgbmVj ZXNzYXJpbHkgcmVmbGVjdCB0aGUgdmlld3Mgb3IgcG9zaXRpb24gb2YgUmFkaWFsIG9yIGl0cyBz dWJzaWRpYXJpZXMgYW5kL29yIGFmZmlsaWF0ZXMuDQoNCg0K