PL/SQL PROCEDURES FOR CURSORS WITH VARIABLE ARGUMENTS IN SELECT STATEMENT

Dear Friends,
I am beginner in PL/SQL programming. I need to write a procedure with cursor varible which can use select with variable parameters.

Example:

PROCEDURE A
(TABLE IN VARCHAR2,
 TIME IN DATE,
  ...)
   CURSOR c1 IS

        SELECT value FROM <table parameter> WHERE TIME1=<time parameter>;    BEGIN
        ...
   END; How can I do it?

Thank you very much in advance

            Robert Received on Fri Feb 05 1999 - 00:46:25 CST