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
