Soft Posts

I was updating the data access layer framework and when I began testing the changes I received this error: "identifier 'PACKAGE.STORED_PROCEDURE_NAME' must be declared ORA-06550". I checked the package name, the procedure name, parameters and their types and nothing.  So then I step-by-step went through the code and found that the connection.open() was not getting executed.  It was buried in a database object and was being skipped.  Painful Oracle error description.

Some symbols cannot be used with XML because most XML parsers will choke on them usually throwing an error.  So you must replace these symbols with their entity reference.  An entity reference begins with an ampersand and ends with a semi-colon and in between includes a multi-character code that represents the original value. Less than (<): replace with &lt; Greater than (>): replace with &gt; Ampersand (&): replace with &amp; Apostrophe ('): replace with &apos; Quotation mark ("): replace with &quot;