Create a procedure and pass a date with out using a cursor?

[Healthc12]

Current Code is
create or replace
PROCEDURE APPEALS(
Selected_EMPLOYEE in STF_STAFF.STF_FORMATTED_NAME%TYPE,
APPEAL_TYPE in MAP_MEM_APPEAL.MAP_APPEAL_TYPE%TYPE,
APPEAL_STATUS in MAP_MEM_APPEAL.MAP_APPEAL_STATUS%TYPE,
rc1 in out spm.rctl) IS
BEGIN
open rc1 for

Now I need to pass a date.

Thanks for the help

 

[SantaMufasa]

HealthC,

First, welcome to Tek-Tips and to the Oracle 10g forum.

In direct response to your posted question, ("Create a procedure and pass a date with out using a cursor?"), can you not add another parameter (a DATE expression) to the APPEALS procedure:

create or replace
PROCEDURE APPEALS(
    Selected_EMPLOYEE in STF_STAFF.STF_FORMATTED_NAME%TYPE,
    APPEAL_TYPE in MAP_MEM_APPEAL.MAP_APPEAL_TYPE%TYPE,
    APPEAL_STATUS in MAP_MEM_APPEAL.MAP_APPEAL_STATUS%TYPE,
    rc1 in out spm.rctl,
    [b]DATE_VAL in DATE[/b]) IS
BEGIN
  open rc1 for...

Let us know if I have missed a key issue for your posting.


Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.