Newby: How to execute an stored Procedure in SQL Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Newby: How to execute an stored Procedure in SQL Plus

  1. #1
    Join Date
    Jul 2003
    Posts
    9

    Newby: How to execute an stored Procedure in SQL Plus

    Can somebody tell me how to execute an stored Procedure in SQL Plus?
    Can you give me an example?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Wink

    Try:


    exec myproc
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    let this be your first proc in your sql*plus...

    Code:
    
    appdev@NICK817.TARRY.LOCAL> declare
      2  l_tst varchar2(30);
      3  begin
      4  null;
      5  end;
      6  /
    
    PL/SQL procedure successfully completed.
    Check out examples on the document lib..
    http://download-west.oracle.com/docs...h8.htm#1013594
    Last edited by Tarry; 08-12-2003 at 05:21 PM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Jul 2003
    Posts
    9
    Thanks!

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