This discussion is archived
5 Replies Latest reply: Nov 19, 2012 1:50 AM by BillyVerreynne RSS

Hello

974834 Newbie
Currently Being Moderated
Hello,
would like to create a procedure using pl/sql code. any suggestions are welcome.

thanks,
rogers
  • 1. Re: Hello
    jeneesh Guru
    Currently Being Moderated
    create or replace procedure p1 is
    begin
      null;
    end;
  • 2. Re: Hello
    SomeoneElse Guru
    Currently Being Moderated
    Do you actually have a question or are you just saying hello?
  • 3. Re: Hello
    only.ashish99 Newbie
    Currently Being Moderated
    declare
    v_line varchar2(40);
    begin
    v_line := 'Hello';
    dbms_output.put_line (v_line);
    end;
  • 4. Re: Hello
    BluShadow Guru Moderator
    Currently Being Moderated
    971831 wrote:
    Hello,
    would like to create a procedure using pl/sql code. any suggestions are welcome.

    thanks,
    rogers
    This is not a question.

    Learn how to ask a question rather than wasting the valuable time of all the volunteers here.

    {message:id=9360002}
  • 5. Re: Hello
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    only.ashish99 wrote:
    declare
    v_line varchar2(40);
    begin
    v_line := 'Hello';
    dbms_output.put_line (v_line);
    end;
    Exactly this type of example of PL/SQL coding that is WRONG in my view.

    PL/SQL is not about writing data to a server session buffer (in the DBMS_SQL package) and then have the client (e.g. TOAD, SQL-Developer, etc) display that buffer content . Giving the illusion to the newcomer that PL/SQL can "write" to the client's display device. When that is not possible.

    This example is not what PL/SQL is about. This is not the information one needs to design and write robust PL/SQL code. It is in fact the exact opposite...

Legend

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