Newsletter #5, January, 22, 2009

How to convert Oracle external C functions to SQL Server

Posted by admin on Jan 19, 2009 • (0)

Here I will describe the migration of functions created as external C libraries in Oracle.  Usually these Oracle functions are defined as CREATE FUNCTION … AS external library … LANGUAGE C. The above statement publishes an external C library through a call specification.

The similar specification in SQL Server 2005/2008 can be written by means of [...]

SQL Server Emulation of Oracle DBMS_PIPE subroutines

Posted by admin on Jan 19, 2009 • (0)

As Oracle DBMS_PIPE mechanism has no direct equivalent in SQL Server, we should provide a method of emulating it. This article describes a possible approach to this task.

The DBMS_PIPE package allows two or more sessions in the same instance to communicate between each other. To do that, one user creates a Pipe. This pipe can [...]

1