Some vaguely structured thoughts on the differences that you see between SQL as implemented by one DBMS and that of another.
Error Type:
OraOLEDB (0x80004005)
?B8
/nar/nvCreateaccount.asp, line 105
This error was caused by assigning a null value to a stored procedure input variable.
OraOLEDB error '80004005'
$?
This error was caused by setting a procedure output parameter as Variant - should be VarChar, for example:
objCommand.parameters.append objCommand.createparameter( "p_device_id", adVarChar, adParamOutput, 24)