Unsupported data type error with XMLTYPE fields.
Posted: Fri 25 Mar 2005 14:04
Hello! I have the follow problem:
1) I'm using ODAC 5.50.0.15 and Delphi 7
2) I`ve created Oracle procedure to update column with XML document:
PROCEDURE CLOBTABLEUPDATE (p_Value XMLTYPE)
is
begin
update MY_TABLE set b = p_Value where id = 100;
end;
3) Using TOraquery with SQL := 'select * from MY_TABLE' I`ve got
"Unsupported data type [58]" error.
How can use params in ODAC components to update fields with XMLTYPE format?
Thank you.
Ilya
1) I'm using ODAC 5.50.0.15 and Delphi 7
2) I`ve created Oracle procedure to update column with XML document:
PROCEDURE CLOBTABLEUPDATE (p_Value XMLTYPE)
is
begin
update MY_TABLE set b = p_Value where id = 100;
end;
3) Using TOraquery with SQL := 'select * from MY_TABLE' I`ve got
"Unsupported data type [58]" error.
How can use params in ODAC components to update fields with XMLTYPE format?
Thank you.
Ilya