The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other direction ...

Oracle has a long history in Visual Studio and Windows shops, but getting Oracle, VS, and related Microsoft technologies to play together nicely can require a little bit of special effort on the ...

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...

PL/SQL stands for Procedural Language extension of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early ...

COMPUWARE ON TUESDAY announced availability of DevPartnerDB Debugger for Oracle for Microsoft Visual Studio .Net, a development tool for debugging Oracle stored procedures from within the Microsoft ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...