Page 1 of 1

Problem with CLOB parameter in stored procedure

Posted: Mon 05 Jan 2009 15:21
by Pegasys
Hi,

I have a stored procedure like this:

Procedure DoSomething(a varchar2,b varchar2,c varchar2, d varchar2, e varchar2,f varchar2,g out clob)

Executing the stored procedure leads to an Oracle Error (ORA-06550: wrong number of types or arguments...).

I found out, the the datatype for the last parameter is set to ftBlob (ParamCheck is done automatically by dbX driver). When I change the datatype to ftOraClob, the procedure is executed correctly.

We are using Delphi 2005 and Oracle 9.2.

Is this a bug or am I doing something wrong?

Best regards,
Pegasys

Posted: Tue 06 Jan 2009 08:28
by Plash
This is a bug in the TSQLStoredProc component. You should manually change DataType of the parameter.

Posted: Tue 06 Jan 2009 08:36
by Pegasys
Thanks for the info, is there any workaround known?

Posted: Thu 08 Jan 2009 09:50
by Plash
Workaround is the one you are already using: manually change DataType of the parameter to ftOraClob.