This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Nov 27, 2012 4:51 AM by P.Forstmann Go to original post RSS
  • 15. Re: Examples of Good Contructed Stored Procedures
    846231 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points