How to retrieve an XML data from a column in DB

[Ramya Devadoss]

After successfully establishing connection with DB

Code:

SQL = "Select * from EMP_MESSAGEQUEUE where WHERE SALESORDERID='MCI-130425-z0S3AL13' " If oConn.State = 1 Then oConn.Execute(SQL) msgbox "executed" selectedRows.open SQL, oConn do until selectedRows.eof EMP_val=selectedRows("EMP_PAYLOAD") msgbox EMP_val selectedRows.movenext loop oConn.close End If

where column EMP_PAYLOAD is of "XMLDATA" type in DB. , but at the place "oConn.Execute SQL" it is prompting error.
Also tried with executing stored procedure still the execute command is throwing an DB error. Could you please help on te executing the stored procedure.

Thanks,