Stored Procedures' issue on duplicated name

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
ghn.henrique
Posts: 4
Joined: Fri 27 Mar 2009 01:24

Stored Procedures' issue on duplicated name

Post by ghn.henrique » Fri 23 Apr 2010 14:56

Hi there,

If I have two stored procedures with the same name, but in different schemas, TSQLStoredProc will duplicated parameters, and it won't execute correctly. I had to create a new procedure, like "ProcName2", as a workaround. Could it be corrected?

There's also another bug within stored procs: it won't let me have a stored proc with a Varbinary(max) parameter in it. It'll raise an exception as I try to execute it.

Cordially,

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 26 Apr 2010 10:12

To solve the problem you should set the StoredProcName property to the "OtherSchema.ProcName" value but not to "ProcName".

Post Reply