Hello Waqas,

ORA-12705 invalid or unknown NLS parameter value specified

Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.

there is two options here :

a) use serializable or read only isolation – the database would be consistent.

b) use flashback query themselves – mandate that you set undo_retention to “X” and then they can just flashback and get a read consistent version of the database back “X” units in time.

anything else does not really make sense. To synchronize the two scheme’s (using flashback) would mean a big bump and grind – AND – would prove that the data they need is flashback queryable – meaning, they didn’t need to copy it, it already exist.

Using regular expressions is probably the best way. You can see a bunch of tests here (taken from chromium)

[code]function validateEmail(email) {
var re = /^(([^<>()[]\.,;:s@”]+(.[^<>()[]\.,;:s@”]+)*)|(“.+”))@(([[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}])|(([a-zA-Z-0-9]+.)+[a-zA-Z]{2,}))$/;
return re.test(String(email).toLowerCase());[/code]
}

Here’s the example of regular expresion that accepts unicode:

[code]var re = /^(([^<>()[].,;:s@”]+(.[^<>()[].,;:s@”]+)*)|(“.+”))@(([^<>()[].,;:s@”]+.)+[^<>()[].,;:s@”]{2,})$/i;[/code]

But keep in mind that one should not rely only upon JavaScript validation. JavaScript can easily be disabled. This should be validated on the server side as well.

[code]function validateEmail(email) {
var re = /^(([^<>()[]\.,;:s@”]+(.[^<>()[]\.,;:s@”]+)*)|(“.+”))@(([[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}])|(([a-zA-Z-0-9]+.)+[a-zA-Z]{2,}))$/;
return re.test(email);
}[/code]

[code]
function validate() {
var $result = $(“#result”);
var email = $(“#email”).val();
$result.text(“”);

if (validateEmail(email)) {
$result.text(email + ” is valid :)”);
$result.css(“color”, “green”);
} else {
$result.text(email + ” is not valid :(“);
$result.css(“color”, “red”);
}
return false;
}

$(“#validate”).bind(“click”, validate);[/code]

[code]<script src=”https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js”></script>

<form>
<p>Enter an email address:</p>
<input id=’email’>
<button type=’submit’ id=’validate’>Validate!</button>
</form>

<h2 id=’result’></h2>[/code]