Convert CHAR to BLOB?

I have a stored procedure that takes a blob as an input parameter. I check to see if the parameter is null by using CURSOR passCur IS

      SELECT NVL(PASSWORD, 'P_at_ssw0rd')
FROM DUAL; PASSWORD is my Blob (it's a bytestream of a hashed password). If nothing is provided, i want to put the word P_at_ssw0rd into the field.

I open the cursor and try to fetch the result into a temporary variable and always get this error.
Error -932: ORA-00932: inconsistent datatypes: expected BLOB got CHAR

Is there something i can do to make sure i put in a BLOB value?

Thanks,
Rob Received on Mon Jun 06 2005 - 12:12:35 CDT