orchestration   

Hi everyone...

I have two question!

1- I have this SP:
  CREATE PROCEDURE _select_mail
  @istat CHAR(6) 
  AS
  SELECT email
  FROM _flusso_mail left join _fatturatore ON _flusso_mail.codresp =   
_fatturatore.codfatt 
  WHERE _flusso_mail.istat=@istat  
  for xml auto, xmldata

And then I have this schema:
<?xml version="1.0" encoding="utf-16" ?> 
  <xs:schema xmlns:ns0="http://createmail2.PropertySchema" 
xmlns="http://createmail2.mail" 
xmlns:b="http://schemas.microsoft.com/BizTalk/2003" 
targetNamespace="http://createmail2.mail" 
xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:annotation>
    <xs:appinfo>
     <b:imports>
      <b:namespace prefix="ns0" uri="http://createmail2.PropertySchema" 
location=".\propertyschema.xsd" /> 
     </b:imports>
    </xs:appinfo>
   </xs:annotation>
   <xs:element name="Root">
    <xs:annotation>
     <xs:appinfo>
      <b:properties>
       <b:property name="ns0:mailaddress" xpath="/*[local-name()='Root' and 
namespace-uri()='http://createmail2.mail']/*[local-name()='email' and 
namespace-uri()='']" /> 
       </b:properties>
     </xs:appinfo>
   </xs:annotation>
   <xs:complexType>
    <xs:sequence>
     <xs:element name="email" type="xs:string" /> 
    </xs:sequence>
  </xs:complexType>
 </xs:element>
</xs:schema>

I want to copy the value of SP.email(that is an attribute) into the 
SCHEMA.email(that is an element).

How can I do this???

2- I insert in a table, in my db, some information. So it's possible that I 
insert the same value, and I have a Violation of PRIMARY KEY.
So how can I capture the message error in the orchestration???

thank you so much

Anja

date: Wed, 15 Mar 2006 09:43:27 -0800   author:   Anja