5 Replies Latest reply: Nov 19, 2012 3:50 AM by Billy~Verreynne RSS

    Hello

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

      thanks,
      rogers
        • 1. Re: Hello
          jeneesh
          create or replace procedure p1 is
          begin
            null;
          end;
          • 2. Re: Hello
            SomeoneElse
            Do you actually have a question or are you just saying hello?
            • 3. Re: Hello
              only.ashish99
              declare
              v_line varchar2(40);
              begin
              v_line := 'Hello';
              dbms_output.put_line (v_line);
              end;
              • 4. Re: Hello
                BluShadow
                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
                  Billy~Verreynne
                  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...