PLS-00386: type mismatch found at 'string' between FETCH
cursor and INTO variables
- 1 Answers
- 6677 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Cause: An assignment target in the INTO list of a FETCH
statement does not match in datatype with the corresponding
column in the select list of the cursor declaration, and it
is unclear which implicit conversion is required to correct
the mismatch.
Action: Change the cursor declaration or change the datatype
of the assignment target. You might want to use datatype
conversion functions in the select list of the query
associated with the cursor.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.
NZE-28890: Entrust Login Failed
IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier
IMP-00064: Definition of LOB was truncated by export
ORA-26095: unprocessed stream data exists
ORA-26028: index string.string initially in unusable state
When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
ORA-16627: No standby databases support the overall protection mode.
ORA-26032: index string.string loading aborted after string keys
ORA-26076: cannot set or reset value after direct path structure is allocated
ORA-26030: index string.string had string partitions made unusable due to:
IMP-00070: Lob definitions in dump file are inconsistent with database.
ORA-26084: direct path context already finished
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
