RE: Strange issue with inserting varchar2()
[email protected] ("Fennell, Brian") Fri, 28 May 2021 00:09:38 +0000
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <MN2PR14MB329493C8EC4BCB9E8AB6AD03A2229@MN2PR14MB3294.namprd14.prod.outlook.com> |
VVRGLTggaGFzIGEgdmFyaWFibGUgbnVtYmVyIG9mIGJ5dGVzIHBlciBjaGFyYWN0ZXIuICBTb21l IGVuY29kaW5ncyBoYXZlIDEgYnl0ZSBwZXIgY2hhcmFjdGVyIGFsd2F5cy4gIFNvbWUgZW5jb2Rp bmdzIGhhdmUgdHdvIGJ5dGVzIHBlciBjaGFyYWN0ZXIgYWx3YXlzLg0KQXNzdW1pbmcgdGhhdCB0 aGUgbnVtYmVyIG9mIGJ5dGVzIGlzIHRoZSBzYW1lIGFzIHRoZSBudW1iZXIgb2YgY2hhcmFjdGVy cyBzb21ldGltZXMgbGVhZHMgdG8gd3JvbmcgYW5zd2Vycy4NCldoZW4geW91IGFyZSB1c2luZyBw ZXJsIGFzIGEgY2xpZW50IHRvIG9yYWNsZSB5b3UgbWF5IGhhdmUgY2hhcmFjdGVycyBpbiBtb3Jl IHRoYW4gb25lIGVuY29kaW5nIHNvIHlvdSBoYXZlIHRvIGJlIHZlcnkgY2FyZWZ1bCB3aXRoIHRo ZSBieXRlIGNvdW50IGFuZCBjaGFyYWN0ZXIgY291bnQuDQpUaGUgcGVybCBsaWJyYXJpZXMgd2hp Y2ggYWNjZXNzIE9yYWNsZSBkYXRhYmFzZSBhcmUgYnVpbHQgd2l0aCBhIHNwZWNpZmljIE9yYWNs ZSBDIExpYnJhcnkgaW1wbGVtZW50YXRpb24sIGFuZCB0aGUgcnVsZXMgZm9yIGNoYXJhY3RlciBl bmNvZGluZyBhbmQgY2hhcmFjdGVyIGJ5dGUgY291bnQgYXJlIHNvbWV0aW1lcyBkaWZmZXJlbnQg ZnJvbSBvbmUgdmVyc2lvbiB0byBhbm90aGVyLg0KSW4gYWRkaXRpb24gdGhlIHBlcmwgcnVsZXMg Zm9yIGNoYXJhY3RlciBjb3VudGluZyBhbmQgYnl0ZSBjb3VudGluZyBhcmUgZGlmZmVyZW50IGZv ciBkaWZmZXJlbnQgdmVyc2lvbnMgb2YgcGVybC4NCkluIGFkZGl0aW9uIHRoZSBPcmFjbGUgRGF0 YWJhc2UgaGFzIGl0cyBvd24gaWRlYSBvZiBjaGFyYWN0ZXIgZW5jb2RpbmcgYW5kIGJ5dGUgY291 bnQuICBBbmQgdGhpcyBhbHNvIGNoYW5nZXMgd2l0aCB2ZXJzaW9uLg0KU28geW91IGFyZSB0aHJl YWRpbmcgbW9yZSB0aGFuIG9uZSBuZWVkbGUgYXQgdGhlIHNhbWUgdGltZSAtIGl0IGNhbiBnZXQg KGFuZCB1c3VhbGx5IGRvZXMgZ2V0KSB2ZXJ5IGNvbXBsaWNhdGVkIHZlcnkgcXVpY2tseS4NClRo ZSB1c3VhbCBzb2x1dGlvbiBpcyB0byB0cnkgdG8gZ2V0IGFsbCB0aGUgbGF5ZXJzIHRvIHVzZSB0 aGUgc2FtZSBlbmNvZGluZyAoYW5kIHRoZXJlZm9yZSB0aGUgc2FtZSBudW1iZXIgb2YgYnl0ZXMg cGVyIGNoYXJhY3RlcikuICBVVEYtOCAod2l0aCBVbmljb2RlIEludGVnZXIgdG8gQ2hhcmFjdGVy IE1hcHBpbmcgYW5kIFVURi04IEJ5dGUgRW5jb2Rpbmcgb2YgdGhlIGludGVnZXJzKSBmb3IgYWxs IGxheWVycyB1c3VhbGx5IHdvcmtzLA0KYnV0IGlmIHlvdSBkb24ndCBoYXZlIGNvbnRyb2wgb3Zl ciBhbGwgdGhlIGxheWVycyB5b3UgbWF5IG5vdCBiZSBhYmxlIHRvIGNob29zZSB0aGlzLg0KQW5v dGhlciBjaG9pY2UgaXMgdG8gZmluZCBvdXQgd2hhdCBjaGFyYWN0ZXIgZW5jb2RpbmcgdGhlIGRh dGFiYXNlIGlzIHVzaW5nIGFuZCB0cnkgdG8gY29uZmlndXJlIGFsbCBvdGhlciBsYXllcnMNCnRv IHVzZSB0aGUgc2FtZSBlbmNvZGluZy4NCkl0IGlzIGFsc28gaGVscGZ1bCB0byBrbm93IHRoYXQg dGhlIEVuZ2xpc2ggbGV0dGVycyBBLVogYW5kIGEteiBhbmQgdGhlIGRpZ2l0cyAwLTkgYXJlIG9m dGVuIGVuY29kZWQgdGhlIHNhbWUgd2F5IGZvciBtYW55IGRpZmZlcmVudCBlbmNvZGluZ3Mgc28g c29tZXRpbWVzIHlvdSBjYW4gY2hlYXQgYnkgZm9yY2luZyBhbGwgb2YgeW91ciBkYXRhIHRvIGJl ICJwdXJlIDcgYml0IGFzY2lpIiBhbmQgaG9waW5nIHRoYXQgYWxsIHRoZSBsYXllcnMgd2lsbCBi ZSAiY2xvc2UgZW5vdWdoIi4NClRoZSBPUyBhbHNvIG1heSBoYXZlIGl0cyBvd24gcnVsZXMgYWJv dXQgY2hhcmFjdGVyIGVuY29kaW5nIHNvIGV2ZW4gdGhlIHNhbWUgdmVyc2lvbiBvZiBwZXJsIG9u IFdpbmRvd3MgYW5kIExpbnV4IG1heSBoYXZlIGRpZmZlcmVudCBlbmNvZGluZyBydWxlcy4NCg0K VGhlIGxhc3QgdGltZSBJIHRyaWVkIHRvIGZpZ3VyZSB0aGlzIG91dCBmb3IgYSByZWFsIGxpZmUg ZXhhbXBsZSBJIHNpbXBseSBnYXZlIHVwIHRyeWluZyB0byB1bmRlcnN0YW5kIGl0IGFuZCBoYWQg dG8gcm9sbCBiYWNrIHRoZSB2ZXJzaW9uIG9mIHBlcmwgQU5EIHRoZSBEQkkgLyBEQkQgbGlicmFy aWVzIChhbmQgdGhlcmVmb3JlIHRoZSB2ZXJzaW9uIG9mIE9yYWNsZSBDIENsaWVudCBMaWJyYXJp ZXMpIHRvIGtub3duIHdvcmtpbmcuDQoNClRvIGJlIGFic29sdXRlbHkgMTAwIHBlcmNlbnQgc3Vy ZSB5b3UgZ2V0IGl0IHJpZ2h0IHlvdSBuZWVkIHRvIHVuZGVyc3RhbmQgdGhlIE9TLCBwZXJsLCBv cmFjbGUgY2xpZW50IGFuZCBvcmFjbGUgc2VydmVyIHJ1bGVzIGluc2lkZSBhbmQgb3V0IC0gYW5k IGZyYW5rbHkgdGhpcyBpcyB2ZXJ5IGhhcmQuDQpFdmVuIGlmIHlvdSB1bmRlcnN0YW5kIGl0IGFs bCBzb21lIGxheWVyIG1heSBzaW1wbHkgbm90IGJlIGFibGUgdG8gZG8gd2hhdCB5b3Ugd2FudCBp dCB0byBkby4NCg0KV2hlbiB0aGUgcGVybCBwcm9ncmFtbWluZyBsYW5ndWFnZSB3YXMgZmlyc3Qg Y3JlYXRlZCB0aGUgaWRlYSB3YXMgdGhhdCBhIGNoYXJhY3RlciB3YXMgYSBieXRlIGFuZCBhIGJ5 dGUgd2FzIGEgY2hhcmFjdGVyIC0gdGhpbmdzIGhhdmUgY2hhbmdlcyBzaW5jZSB0aGVuIC0gbW9y ZSB0aGFuIG9uY2UuDQpUaGUgc2FtZSBpcyB0cnVlIG9mIHRoZSBPcmFjbGUgRGF0YWJhc2UgYW5k IGNsaWVudCBsaWJyYXJpZXMgLSAoYW5kIFdpbmRvd3MgYW5kIExpbnV4KSAtIHRoZSBncm93aW5n IHBhaW5zIGxlZnQgYSBsb3Qgb2Ygc3RyYW5nZSBhcnRpZmFjdHMgYmVoaW5kIGluIGFsbC4NCg0K QW5vdGhlciB0cmljayBpcyBtYWtlIGFsbCBidWZmZXJzIDQgdGltZXMgYXJlIGJpZyBhcyB5b3Ug dGhpbmsgeW91IHJlYWxseSBuZWVkIHRoZW0gYW5kIHRoZW4gaGF2ZSB0aGUgZGF0YWJhc2UgY29u Y2F0IHRoZSBkYXRhIHRvZ2V0aGVyIG9uIHRoZSBzZXJ2ZXIgc2lkZSAtIGRvIGluIHRoZSBlbmQg eW91IGFyZSBvbmx5IHdvcmtpbmcgd2l0aCBvbmUgbGF5ZXIuDQpMYXN0IHRpbWUgSSBjaGVja2Vk IDQgYnl0ZXMgcGVyIGNoYXJhY3RlciB3YXMgdGhlIHdvcnNlIGNhc2Ugc2NlbmFyaW8uICBJdCBt aWdodCBiZSA4IGJ5IG5vdy4NCg0KVGhlcmUgYXJlIGFsc28gImxvc3NsZXNzIiB3YXlzIG9mIGVu Y29kaW5nICJpbGxlZ2FsIGNoYXJhY3RlcnMiLCBzdWNoIGFzIFVURi04IGVuY29kZSBmaXJzdCB0 aGVuIE1pbWUgUS1FbmNvZGUgKHF1b3RlZCBwcmludGFibGUpIG9yIHVzaW5nIFhNTCAvIFhIVE1M IGVudGl0aWVzIGxpa2UgdGhpcyAtICYjMTI0OyBvciBVVEYtOCBlbmNvZGUgdGhlbiBwZXJjZW50 LWVuY29kZS4NClRoaXMgY2FuIGJlIHVzZWQgd29yayBhcm91bmQgc3BlY2lhbCBjaGFyYWN0ZXJz IHdoZW4geW91IGFyZSBkZWFsaW5nIHdpdGggbW9zdGx5IEVuZ2xpc2ggd2l0aCBzb21lIEV1cm9w ZWFuIGNoYXJhY3RlcnMgYW5kIGFuIGVuY29kaW5nIHRoYXQgaXMgZWl0aGVyIDctYml0LWFzY2lp IGNvbXBhdGlibGUgb3IgY2FuIGVhc2lseSBiZSBjb252ZXJ0ZWQgdG8gYW5kIGZyb20gKGxvc3Ns ZXNzbHkpIDctYml0LWFzY2lpIChzdWNoIGFzIEVCQ0lESUMgd2l0aCBzb21lIGNyZWF0aXZpdHkp Lg0KQW5kIHRoZXJlIGlzIGFsd2F5cyBnb29kIG9sZCBoZXhhZGVjaW1hbC4NCg0KSXQgYWxsIGRl cGVuZHMgb24geW91ciB1c2UtY2FzZXMsIGhvdyBtdWNoIGNvbnRyb2wgeW91IGhhdmUgb3ZlciB5 b3VyIGVudmlyb25tZW50IGFuZCBob3cgbXVjaCB0aW1lIHlvdSBjYW4gc3BlbmQgYmVpbmcgY2xl dmVyLg0KDQoNCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQnJ1Y2UgSm9o bnNvbiA8am9obnNvbkBQaGFybWFjeS5Bcml6b25hLkVEVT4NClNlbnQ6IFRodXJzZGF5LCBNYXkg MjcsIDIwMjEgNzozNiBQTQ0KVG86IGRiaSB1c2VycyA8ZGJpLXVzZXJzQHBlcmwub3JnPg0KU3Vi amVjdDogW0VYVEVSTkFMXSBTdHJhbmdlIGlzc3VlIHdpdGggaW5zZXJ0aW5nIHZhcmNoYXIyKCkN Cg0KSSdtIHdvcmtpbmcgb24gYW4gYXBwIHRoYXQgcHJvY2Vzc2VzIChhbW9uZyBvdGhlciB0aGlu ZykgbG9uZyBzZWN0aW9ucyBvZiB0ZXh0LCBhbmQgSeKAmW0gcnVubmluZyBpbnRvIG9kZCBtdWx0 aS1ieXRlIGNoYXJhY3RlcnMgaW4gc29tZSBvZiB0aGUgZW50cmllcy4NCg0KVGhlIGNvbHVtbiBp biBxdWVzdGlvbiBpcyBhIHZhcmNoYXIyKDQwMDApIHNvIEkgYW0gdHJ1bmNhdGluZyB0aGUgaW5w dXQgdG8gNDAwMCBieXRlcy4NCg0KKHZpYSB1c2Ug4oCcYnl0ZXM7ICRzdHJpbmc9c3Vic3RyKCRv cmlnLDAsNDAwMCk7IOKAnSBpbiB0aGUgc2VjdGlvbiB3aGVyZSBJIGFjdHVhbGx5IHRydW5jYXRl IHRoZSBzdHJpbmcuKQ0KDQpXaGVuIEkgZG8gdGhlIGluc2VydCBJIGdldCBhbiAgT1JBLTEyODk5 OiB2YWx1ZSB0b28gbGFyZ2UgZm9yIGNvbHVtbiAiQVdBUkQiLiJQUkVDRVBUX05PTUlOQVRJT05T Ii4iT05DT0xPR1lfQ09NTUVOVFMiIChhY3R1YWw6IDQwNTQsIG1heGltdW06IDQwMDApIGVycm9y DQoNCldoZW4gSSBjaGVjayB0aGUgYWN0dWFsIGxlbmd0aCBvZiB0aGUgb2ZmZW5kaW5nIHN0cmlu ZyBpbiBieXRlcyBvbiB0aGUgcGVybCBzaWRlIGl0IGlzIDQwMDAgKmJ5dGVzKiBsb25nDQoNCk9y aWdpbmFsIE9uY29sb2d5IGNvbW1lbnQgaXMgNDgwNCBjaGFycyAoNDgyNCBieXRlcykgbG9uZyBh bmQgd2hlbiB0cnVuY2F0ZWQgaW4gY2hhcmFjdGVyIG1vZGUgdG8gNDAwMCBjaGFycyBpdOKAmXMg NDAxOCBieXRlcyBsb25nLCB3aGVuIHRydW5jYXRlZCBpbiBieXRlIG1vZGUsIGl04oCZcyA0MDAw IGNoYXJzIGFuZCBieXRlcy4NCg0KV2hhdOKAmXMgY29uZnVzaW5nIG1lIGlzIHRoYXQgdGhlIHNp emUgb2YgdGhlIHN0cmluZyBiZWluZyByZXBvcnRlZCBieSBvcmFjbGUgaW4gdGhlIGVycm9yIGRv ZXNu4oCZdCBtYXRjaCBhbnkgb2YgdGhlIHZhbHVlcyB0aGF0IEkgc2VlIGluIHBlcmwuIEnigJlt IG5vdCBzdXJlIHRoaXMgaXMgYSBEQkkgaXNzdWUgb3Igbm90Lg0KDQotLQ0KQnJ1Y2UgSm9obnNv bg0KVW5pdmVyc2l0eSBvZiBBcml6b25hDQpDb2xsZWdlIG9mIFBoYXJtYWN5DQpJbmZvcm1hdGlv biBUZWNobm9sb2d5IEdyb3VwDQoNCkluc3RpdHV0aW9ucyBkbyBub3QgaGF2ZSBvcGluaW9ucywg bWVyZWx5IGN1c3RvbXMNCg0KDQoNCg0KVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlz IGVsZWN0cm9uaWMgbWFpbCB0cmFuc21pc3Npb24gaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHVz ZSBvZiB0aGUgaW5kaXZpZHVhbCBvciBlbnRpdHkgbmFtZWQgaW4gdGhpcyB0cmFuc21pc3Npb24u IElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb2YgdGhpcyB0cmFuc21pc3Np b24sIHlvdSBhcmUgaGVyZWJ5IG5vdGlmaWVkIHRoYXQgYW55IGRpc2Nsb3N1cmUsIGNvcHlpbmcg b3IgZGlzdHJpYnV0aW9uIG9mIHRoZSBjb250ZW50cyBvZiB0aGlzIHRyYW5zbWlzc2lvbiBpcyBz dHJpY3RseSBwcm9oaWJpdGVkIGFuZCB0aGF0IHlvdSBzaG91bGQgZGVsZXRlIHRoZSBjb250ZW50 cyBvZiB0aGlzIHRyYW5zbWlzc2lvbiBmcm9tIHlvdXIgc3lzdGVtIGltbWVkaWF0ZWx5LiBBbnkg Y29tbWVudHMgb3Igc3RhdGVtZW50cyBjb250YWluZWQgaW4gdGhpcyB0cmFuc21pc3Npb24gZG8g bm90IG5lY2Vzc2FyaWx5IHJlZmxlY3QgdGhlIHZpZXdzIG9yIHBvc2l0aW9uIG9mIFJhZGlhbCBv ciBpdHMgc3Vic2lkaWFyaWVzIGFuZC9vciBhZmZpbGlhdGVzLg0KDQoNCg==