Help with a sproc using a xml input parm
 

I’m new to Vb.net or VB in general and need help executing a sproc with
a well-formed XML input

Here is the short version of it


Alter procedure dob.RTC_Customer_Update
( @XMLData ntext = null,

@vUser varchar(10))


as
declare @nError int
declare @sMode varchar(10)
declare @vnName varchar(100)
declare @sErrorDesc varchar(100)
declare @dTodate datetime,
@XMLHnd int

declare @TMp table (NCUSTKEY
numeric ( 6 ) ,
VCNTRYCODE
varchar ( 2 ) ,
VIDTYPE
varchar ( 1 ) ,
..
..
..
..
..
..
..
..
..
..
..
..
..
Mode
int)

begin transaction
set nocount on
if @XMLData is null
begin
select @nError=5
end

select @dToday = getdate()
EXEC sp_xml_preparedocument @XMLHnd OUTPUT, @XMLData
Inset into @Tmp (NCUSTKEY ,
VCNTRYCODE ,
VIDTYPE ,