Hi
I'm working on an error handling for my import.
Therefore I would like to log invalid stuff in a table.
This works fine so far
insert into MyErrorTable (Clm1, Clm2, Clm3, ..., Clm20, Clm_WhatHappened)
select (Clm1, Clm2, Clm3, ..., Clm20, 'nonsence_static_Text'
from MySourceTable;
Now I would like to insert the SQLERRM
insert into MyErrorTable (Clm1, Clm2, Clm3, ..., Clm20, Clm_WhatHappened)
select (Clm1, Clm2, Clm3, ..., Clm20, SQLERRM
from MySourceTable;
But I get
"PL/SQL: ORA-00904: "SQLERRM": invalid identifier"
Did I understand somethong wrong with the insert-command?
Is it necessary to create one gigantic varchar-string?
Thank you for reading!
pAT
Edited by: pAT on Apr 19, 2011 5:35 AM