Now when I look at the value in the session it reports this: 08/01/2012I don't understand this because the value of AI_PATIENT_BIRTH_DATE according to the URL you supplied should have been *03/07/2001*.
What is this format?It appears to be MM/DD/YYYY. Fairly standard -- so I'm missing something.
SELECT to_date(:AI_PATIENT_BIRTH_DATE,'MM/DD/YYYY') INTO l_birth_date from dual;That is bizarre. If what you have showed is correct, then I'd suspect a non-printing character. I don't really know, though.
But this fails with the following error:
SELECT to_date(replace(:AI_PATIENT_BIRTH_DATE,'/','/'),'MM/DD/YYYY') INTO l_birth_date from dual;It makes no sense that this works and the previous one did not. The only difference is the REPLACE which is replacing a character with itself... so far as I can tell. The other possibility, I suppose, is that there are characters which are not showing up due to the nature of the forum posting. If there are HTML tags, they'll get filtered out of your post.
Shawn Kessler wrote:In 4.2 there is a new HTML Escaping Mode security attribute, which is set to "Extended" by default. You can find it under Edit Application Properties > Security > Browser Security. Setting it to "Basic" may restore the previous behaviour. (This setting might not be visible if Edit Application Properties > Properties > Compatibility Mode isn't set to *4.2*.)
Thanks for the response. Indeed the post made no sense because the forum has altered the appearance of my text.
The value seen in the application item is 08&#x2F;01&#x2F;2012
Which means the select that works actually looks like this:
SELECT to_date(replace(:AI_PATIENT_BIRTH_DATE,'&#x2F;','/'),'MM/DD/YYYY') INTO l_birth_date from dual;