Hi,
I have stored procedure in MSSQL, that need to be translated to Oracle.
SP in MSSQL
CREATE PROCEDURE [dbo].[pptChnlGrpChnl_d_xml]
@xmlOptinChannel nvarchar(max) --<TeamProfile><UserProfile companyTeamID="" userID="" /></TeamProfile>
AS
DECLARE @docid int
DECLARE @TableOptins table (
OptinChannelGroupID int,
ChannelID int
)
EXEC sp_xml_preparedocument @docid OUTPUT, @xmlOptinChannel
-- Populate temp table with user(s) records for removal
INSERT INTO @TableOptins (OptinChannelGroupID, ChannelID)
SELECT tm.OptinChannelGroupID, tm.ChannelID
FROM OPENXML (@docid, '/GroupChannels/GroupProfile')
WITH (OptinChannelGroupID int,
ChannelID int) tm
EXEC sp_xml_removedocument @docid
Return 0
Any suggestion?