PLS-00385

Error: PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

Causa: The expressions to the left and right of the INTO clause in a SELECT...INTO statement do not match in datatype, and it is unclear which implicit conversion is required to correct the mismatch.

Acción: Change the expressions so that their datatypes match. You might want to use datatype conversion functions in the select list.