Feeds:
Posts
Comments

Archive for the ‘Oracle’ Category

How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command

Introduction

Using Oracle Stored Procedures in SqlDataSource Select command is not straightforward. When you return recordset from Oracle SP, you have to declare out parameter of sys_refcursor type, which is not possible without handling Selecting event on the data source.

Background

To do that, I’ll demonstrate two ways, one with simple code behind handler of the Selecting event, and the other with developing custom Parameter control, and sub classing SqlDataSource control. The latter is more complicated, but it gives you the ability to use stored procedures not only from Oracle, but from all databases which return cursors from their stored procedures.

(more…)

Advertisements

Read Full Post »