Function: Return PL /SQL table or VARCHAR2

From: Suyam <suzuyam1102001_at_yahoo.com>
Date: 24 Oct 2001 18:22:47 -0700
Message-ID: <17e20f7a.0110241722.6a5dba8b@posting.google.com>

How can I return either " Retrun Pl/SQL table" or "Return VARCHAR2" simultaneously which are dependable on Count(Last_name) condition?

Thanks,
Suyam

The below is imcomplete because I can not understand the above point.

---

create or replace function New_Rental(

P_last_name  S_member.LAST_NAME%TYPE,
P_member_id  S_member.Member_id%TYPE,
P_first_name S_member.FIRST_NAME%TYPE,
P_phone      S_member.Phone%TYPE,
P_VALID_DATE In OUT Date)

Return VARCHAR2
Is
V_msg :='Expected due date is'||P_VALID_DATE;

Begin
If Count(Last_name)=1 then
Select VALID_DATE INTO P_VALID_DATE
 from S_member
 Where Last_Name:= P_Last_name;
 return 'Expected due date is'||P_VALID_DATE;

ElSIF Count(Last_name)> 1 then
Select VALID_DATE INTO P_VALID_DATE
 from S_member
 Where Last_name:=P_last_name And Member_id:= P_member_id; ---I would like to input retun PL/ SQl table here. How can I do that?  return 'Expected due date is'||P_VALID_DATE||'Person's record as follows:'||P_last_name,P_first_name, P_phone, P_member_id ;

Else Count(Last_name)=0
return'This person needs to be registered as a member' End If;
End New_Rental;

---

Received on Wed Oct 24 2001 - 20:22:47 CDT