PLS-00517 – Oracle Error Code

Type mismatch between a select list element ‘string’ and corresponding table column in INSERT statement with a subquery