Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to create cursor inside begin/end block in pl/sql

Re: How to create cursor inside begin/end block in pl/sql

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Wed, 6 Dec 2006 00:08:20 -0800 (PST)
Message-ID: <20061206080821.37166.qmail@web58715.mail.re1.yahoo.com> 





>We have a requirement that depending upon the input parameter passed we have to declare the cursor accordingly.

Harvinder

You can use PL/SQL cursor variables; see the PL/SQL User Guide and Reference - which includes examples - at:
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/06_ora.htm#1510


Regards Nigel


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Dec 06 2006 - 02:08:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US