Problem with CLOB parameter in stored procedure

Problem with CLOB parameter in stored procedure

Postby 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
Pegasys
 
Posts: 3
Joined: Mon 05 Jan 2009 15:07

Postby Plash » Tue 06 Jan 2009 08:28

This is a bug in the TSQLStoredProc component. You should manually change DataType of the parameter.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Pegasys » Tue 06 Jan 2009 08:36

Thanks for the info, is there any workaround known?
Pegasys
 
Posts: 3
Joined: Mon 05 Jan 2009 15:07

Postby Plash » Thu 08 Jan 2009 09:50

Workaround is the one you are already using: manually change DataType of the parameter to ftOraClob.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle