Devart Forums

Posted: **Fri 11 Jun 2010 09:10**

Hi,

Version 5.90.0.57

You cannot use a stored procedure with NCHAR parameter.

To reproduce:

1) create a stored procedure like this:

Code: Select all

CREATE PROCEDURE P_nchar_test(test NChar(100))
  READS SQL DATA
begin
end

MySQL happily accepts.

2) drop a TMyConnection on the form, connect it to your database

3) drop a TMyStoredProc on the form, attach it to your connection component

4) set the TMyStoredProc.StoredProcName to the above procedure

Error raised:
----------
Unknown column type "NCHAR" in "test NChar(100)".

Call stack:
----------
[0EB76662]{mydac120.bpl} Myclasses.TMySQLCommand.DescribeParams + $726
[0EB776C0]{mydac120.bpl} Myclasses.TMySQLCommand.CreateProcCall + $B4
[1603956C]{dac120.bpl } Dbaccess.TCustomDASQL.InternalCreateProcCall + $74
[1602E32D]{dac120.bpl } Dbaccess.TCustomDADataSet.InternalCreateProcCall + $21
[0EB9EC23]{mydac120.bpl} Myaccess.TCustomMyStoredProc.PrepareSQL + $1F
[0EB9EBDC]{mydac120.bpl} Myaccess.TCustomMyStoredProc.SetStoredProcName + $74
[5003F6FD]{rtl120.bpl } TypInfo.SetUnicodeStrProp (Line 2127, "TypInfo.pas" + 24) + $5
...

Please send me a fix for this, I need it urgently!

With regards,

Martijn Tonies
Upscene Productions

Posted: **Fri 11 Jun 2010 10:45**

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Posted: **Fri 11 Jun 2010 10:48**

Dimon wrote:Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Hello Dimon,

Any idea when that build is going to be released?

Thanks.

Posted: **Fri 11 Jun 2010 10:52**

The next MyDAC build will be released next week.

Devart Forums

Stored Procedures fail with N(VAR)CHAR

Stored Procedures fail with N(VAR)CHAR