Equivalent SQL Server master.dbo.sysprocesses table in Oracle?
616017Sep 18 2008 — edited Sep 23 2008Hello,
This is my SQL Server stored procedure that I'm having trouble migrating to Oracle. I think I need to query the v$session table in Oracle to get the SID. What is the equivalent column to context_info....v$session.CLIENT_INFO??
CREATE PROCEDURE [dbo].ALL_Source_Push
@source uniqueidentifier
AS
SET NOCOUNT ON
DECLARE @info VARBINARY(128)
SELECT @info = context_info FROM master.dbo.sysprocesses WHERE spid = @@spid
set @info = CAST(@source as BINARY(16)) + CAST(LEFT(@info, 112) as VARBINARY(112))
SET CONTEXT_INFO @info
GO
Edited by: Mimi Miami on Sep 18, 2008 4:02 PM