Oracle and SQL Server both have them. Data types that are tables that
can be passed into a stored procedure via parameters or returned. Most
people might think of it as convenient composite type that allows the
communicating more complex data between procedures and applications.
The only way to get around this limitation today is to design around
it. Visibility limitations between procedure scopes limit the ability
to share working tables, unless the data within them is indexed such
that one process' data can be kept separate from another using the same
procedures.
Isn't this an old idea? It's part of SQL Server 2000, and Oracle's has
been around since 1992. Makes me wonder what Sybase is spending their
R&D money on.
--
Visit <http://blogs.instreamco.com/anything.php>
to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/>
for politics, society and culture.
