CodeSnip: Using Dynamic Cursor in a Procedure Using Oracle 9i: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: Using Dynamic Cursor in a Procedure Using Oracle 9i

page 1 of 4

Published: 21 May 2008

Abstract
In this code snippet, Deepankar examines the usage of dynamic cursors in a procedure where the table name is passed as an input parameter. After listing the SQL code sample, he analyzes it and then provides a screenshot of the final output.

by Deepankar Sarangi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 4448/ 149

Article Contents:

Introduction

When the table to be used inside a cursor is not known to the user while creating the procedure, a ref cursor can be used to pass the name of the table dynamically as the input parameter to the procedure. The procedure also serves the purpose of being used again and again for many different tables of similar type as per the business requirement.

Requirements

Oracle database 9i

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 5 and type the answer here:

User Comments

Title: Passing Table from .Net
Name: Jegan
Date: 5/30/2008 1:42:32 AM
Comment:
Hi Deepankar Sarangi

This is goood,now i wanted to pass datatable from .Net to oracle stored procedure.
Pls reply

Jegan