Delphi 2010 - Calling an SP with XML parameters.

Delphi 2010.  SQL Server 2008.

I need to call a stored procedure defined as:

ALTER PROCEDURE [dbo].[OriginalData2012Validate]

  @xmlData xml,
  @xmlErrors xml output

AS
BEGIN
...

The data types are xml.  Can i call this stored procedure from Delphi 2010?  

 At the moment the parameter types are being defined as "widestring" which then causes problems in the stored procedure.

Any work arround?
soozhAsked:
Who is Participating?
 
Sinisa VukCommented:
Doesn't exists, maybe is Blob type behind this? Try to pass xml as blob.
Also take a look...
http://embarcadero.newsgroups.archived.at/public.delphi.database.ado/200908/090826844.html
0
 
Sinisa VukCommented:
Try to use utf8 string - and in xml string must be: <?xml version="1.0" encoding="UTF-8"?>...
0
 
soozhAuthor Commented:
thanks but utf8 is not a parameter type.

maybe xml parameters do not exist in Delphi 2010?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.