Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: how to do we call procedure from pl/sql

    Hi,

    can you send the code how can we call the stored procedure through a pl/sql block, because iam getting confused with this topic,can any one help in this matter? and pls send some example code for calling a proc

    bye

    thank you

  2. #2
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Hi,

    See the sample code here...

    BEGIN
    DBMS_OUTPUT.PUT_LINE("This is the pout put from procedure");
    END;

    same way you can call the functions / packages...
    Regards
    Suneel

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    declare
    ......
    ......
    begin
    Proc1('Hello','World');
    end;
    /
    SATHISH .

Posting Permissions

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