Problem with CLOB parameter in stored procedure

Pegasys · Post by **Pegasys** » Mon 05 Jan 2009 15:21

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

Plash · Post by **Plash** » Tue 06 Jan 2009 08:28

This is a bug in the TSQLStoredProc component. You should manually change DataType of the parameter.

Pegasys · Post by **Pegasys** » Tue 06 Jan 2009 08:36

Thanks for the info, is there any workaround known?

Plash · Post by **Plash** » Thu 08 Jan 2009 09:50

Workaround is the one you are already using: manually change DataType of the parameter to ftOraClob.