Parameterized cursors in PL/SQL

From: Rene Hoekstra <Rene.Hoekstra_at_rivm.nl>
Date: 1995/11/15
Message-ID: <48d59a$f44_001_at_trout.rivm.nl>#1/1

Hi all,

Can I pass a table name as a parameter to a cursor in PL/SQL as in :

  declare

	cursor c_1 (tname IN VARCHAR2) is
	  select <col1>, <col2> ... <coln>
	  from   tname
	  where  <where_clause>;

  ...
  begin

	...
	open c_1 (<tablename>)
	...

  end;

I've tried the above statement, but it doesn't work. Anyone have a solution to this ?

Thanx for any help,
Rene.

---

| Rene Hoekstra
| E-Mail : Rene.Hoekstra_at_rivm.nl
| National Institute of Public Health and Environmental
| Protection (R.I.V.M.)
| Bilthoven, The Netherlands

---

      " Alleen slaapwandelaars kunnen in slaap vallen "

---

Received on Wed Nov 15 1995 - 00:00:00 CET