PLS-00385: type mismatch found at 'string' in SELECT...INTO
statement
- 1 Answers
- 2845 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: 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.
Action: Change the expressions so that their datatypes
match. You might want to use datatype conversion functions
in the select list.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
ORA-09808: Could not obtain user clearance.
ORA-32771: cannot add file to bigfile tablespace
ORA-02208: duplicate MAXTRANS option specification
NNO-00809: Unknown OCI error: number
ORA-02055: distributed update operation failed; rollback required
ORA-23413: table "string"."string" does not have a materialized view log
NNL-00803: Queries received, type ALIAS: number
ORA-36686: (XSDPART24) Value number is not in partition number.
PCC-02408: Expecting an expression of some Object type
ORA-12823: default degree of parallelism may not be specified here
NNL-00550: flush [<server_list>] : flush one or more servers' cache(s)
LSX-00230: invalid integer "~S"
Oracle Errors 
