Home -> Usenet -> c.d.o.tools -> How about a *FUNCTION* that'd return a ResultSet ??

How about a *FUNCTION* that'd return a ResultSet ??

From: <monsri_at_my-deja.com>
Date: Fri, 01 Sep 2000 10:26:42 GMT
Message-ID: <8oo08n$47h$1_at_nnrp1.deja.com> 






Hi,


[Quoted] Let's say I have the following table TAB_1:


 CHP_1                            CHP_2
 ----- --------------------------------
    23  chaine1 chaine2 chaine3 chaine4
    24      truc_1 truc_2 truc_3 truc_4





 I'd like to be able to get with this SELECT:


 > SELECT chp1, TORESULTSET(chp2)


 > FROM TAB_1;




 the following output:


 CHP_1 TORESULTS



    
  
  •   ---------
    23   chaine1
    23   chaine2
    23   chaine3
    23   chaine4
    24    truc_1
    24    truc_2
    24       ...






 but I'm afraid it's UTTERLY impossible with Oracle
 (I checked the PL/SQL manuals I have at REF CURSOR,
 but all examples are given with procedures; I'd
[Quoted]  really like to perform this with a function...).



 If anybody can gimme some hints...



 Thanks a lot !



seb




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Fri Sep 01 2000 - 12:26:42 CEST












Original text of this message