Solved

Delphi 2010 - Calling an SP with XML parameters.

Posted on 2013-05-27
3
356 Views
Last Modified: 2013-06-03
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?
0
Comment
Question by:soozh
  • 2
3 Comments
 
LVL 25

Expert Comment

by:Sinisa Vuk
ID: 39199004
Try to use utf8 string - and in xml string must be: <?xml version="1.0" encoding="UTF-8"?>...
0
 

Author Comment

by:soozh
ID: 39199011
thanks but utf8 is not a parameter type.

maybe xml parameters do not exist in Delphi 2010?
0
 
LVL 25

Accepted Solution

by:
Sinisa Vuk earned 500 total points
ID: 39199047
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now