I got ” PLS-00382: expression is of wrong type ” error in Oracle database.
PLS-00382: expression is of wrong type
Details of error are as follows.
PLS-00382: expression is of wrong type Cause: An expression has the wrong datatype for the context in which it was found. Action: Change the datatype of the expression. You might want to use datatype conversion functions.
expression is of wrong type
This PLS-00382 errors are related with the expression has the wrong datatype for the context in which it was found.
If you mix data types, you will get this error.
For example; Your column data type number, but you are assigning the varchar value, so you will get this error.
To solve this error, Change the datatype of the expression.
You might want to use datatype conversion functions.
And don’t forget to mix data types when assign value to any column.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )