It's always good to post a code example of what you have done, even if it does not work yet. It is difficult to know what you are trying to do based on your description. Regards, Mike
On Fri, Feb 11, 2011 at 10:11 PM, Shoeb Bojagar <shoeb.boja...@gmail.com>wrote: > The first difficulty is that i am unable to create a temporary table > which i need to select the required data and return it, Dynamic sql is > used for ddl staments like create table but i am still not able to do > it correctly as my procedure is quite complex involving joins and many > tables and i am not sure about the single Colan( ' ) thats placed > before the query begins where it ends and again where it starts.. > Secondly i am using sys_refcursor and not sure if it will return the > whole data set, so i need to know how can i return the whole temporary > table or the complete result set. like in postgres we use after the sp > declaration ' RETURNS SETOF refcursor AS' and at the end of sp we just > write RETURN NEXT ref1 > > -- > Shoeb Bojagar. > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
