Hi
Under Oracle 19c I made a simple select with cursors :
select
'file1' as "filename",
cursor(
select
a.NOM "nom",
:P17_DATE_CALCULEE as "date_devis",
a.PRENOM as "prenom",
a.ADRESSE as "adresse",
a.CODE_POSTAL as "code_postal",
a.VILLE as "ville",
a.TELEPHONE as "telephone",
:P17_TOTAL as "total",
a.ID as "numero_devis",
cursor ( select
b.motif as "motif",
b.DESTINATION as "destination",
b.DISTANCE as "distance",
b.PRIX as "prix"
from DY_DEVIS_LIGNE b
where B.ID_DEVIS = :P17_NUMERO)
from DY_DEVIS a
where a.ID = :P17_NUMERO
) as "data"
from dual
I get an error ORA-00932 inconsistent datatype :
What is wrong with the cursor ?
Best regards.