how to execute /run the procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to execute /run the procedure

  1. #1
    Join Date
    Jul 2002
    Posts
    32

    how to execute /run the procedure

    Folks , a beginner in pl/sql

    I have written a package and package body.

    I ran the above package and procedure query and it said
    sql >package body created
    sql > package created

    Now i want to execute / run this procedure how will i do the same.

    thanks in regards
    shivanand
    Mumbai
    SHIVANAND HANUMANTAPPA

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    SQL> exec package_name.procedure_name;

    F.ex
    Code:
    SQL> SET SERVEROUTPUT ON
    SQL> EXEC DBMS_OUTPUT.PUT_LINE('Hello');
    Hello
    
    PL/SQL procedure successfully completed.

  3. #3
    Join Date
    Mar 2003
    Posts
    4
    begin
    package_name.name_of_procedure;
    end;
    :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width