DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to execute a procedure of the package?

  1. #1
    Join Date
    Dec 2000
    Posts
    95

    Question How to execute a procedure of the package?

    Hi,

    How do we execute a procedure of a package? I have executed the procedure of a package as follows but it was failed.

    execute PackageName..ProcedureName

    Is the above syntax is correct in Oracle8.1.7?

    Thanks in advance.

    Srinivas Medukonduru

  2. #2
    Join Date
    Jul 2003
    Posts
    53

    U R Correct

    exec package name.procedure name(parameters)
    anu

  3. #3
    Join Date
    Dec 2000
    Posts
    95

    Question How to execute a procedure of the package?

    Thank you for the syntax. Is the following syntax is correct in case of no parameter for a procedure of a package?

    exec packageName.PorcedureName

    Thanks in advance.

    Srinivas Medukonduru

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Yes, thats correct.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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