Joe Stanton
Member
Just wondering if anyone has a in-depth error checking plug-in. We are finding script that past developers have crafted with code that has incorrect data types being specified to be inserted (these are conditional with DECODE statements inline). These cause the particular SQL statement to fail after a portion of the records have been inserted.
Would be much better to detect all such incorrect mapping by a tool that matches SELECTed fields, or VALUE items, to the target INSERT field - this should also work with Cursor/Row variables.
Thanks for responses via email.
jstanton@accela.com
Would be much better to detect all such incorrect mapping by a tool that matches SELECTed fields, or VALUE items, to the target INSERT field - this should also work with Cursor/Row variables.
Thanks for responses via email.
jstanton@accela.com
