Procedure data type?

From: Gabba <nofake_at_mail.com>
Date: Wed, 16 Jun 1999 12:51:02 GMT
Message-ID: <37679b3e.6653285_at_news.tel.hr>

Oracle 8!
How to create procedure that accept tablename and columnname as input params and processed them in select statement ????

for example...

create or replace procedure TestProc (
vTable in ??TYPE, vField in ??TYPE ,vKey in char , vCursor out mypackage.xCursor )
as
begin
  open vCursor for select * from vTable where vField = vKey; end TestProc;
/

Thnx! Received on Wed Jun 16 1999 - 14:51:02 CEST