Database Dynamic Parameters

Question

Hi,

 I was wondering if we can pass only one parameter which can held any kind of parameter in databasse in xml form and there we extract and use as per requirement.

 

Thus we may have only one parameter as per procedure which can have any parameter in any quantity.

 

such as:

create proc sp1 @xml text
begin
Declare params int;
set params=ExtractValue('root',@xml);
.......
 
End

My question is this process is ok or have any major flaws?