1 2 Previous Next 16 Replies Latest reply: Nov 27, 2012 6:51 AM by P.Forstmann Go to original post RSS
      • 15. Re: Examples of Good Contructed Stored Procedures
        846231
        Wow you are a genius P.F :)

        Thank you very much....

        Long live everyone!


        PS. Hi PF, can you share me some of the PL/SQL codes or other sites you explored? Like the tricks above, it is hard to formulate that if your not an expert. ;)


        One last question, if I placed serveroutput on.....and my stored proc is run by DBMS.Scheduler, where does my output go?

        Edited by: KinsaKaUy? on 27-Nov-2012 04:44
        • 16. Re: Examples of Good Contructed Stored Procedures
          P.Forstmann
          KinsaKaUy? wrote:
          PS. Hi PF, can you share me some of the PL/SQL codes or other sites you explored? Like the tricks above, it is hard to formulate that if your not an expert. ;)
          One very good site is asktom.oracle.com when PL/SQL code is written by Tom Kyte to answer a question (and sometimes other people too but this depends ...)
          One last question, if I placed serveroutput on.....and my stored proc is run by DBMS.Scheduler, where does my output go?
          Answer from Tom Kyte: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:388480262167#181851200346292311 .
          1 2 Previous Next