[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Delphi 2010 - Calling an SP with XML parameters.

Posted on 2013-05-27
3
Medium Priority
?
410 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

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 28

Accepted Solution

by:
Sinisa Vuk earned 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

656 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