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

Thread: How to access a pl sql procedure through web?

  1. #1
    Join Date
    Jun 2016
    Posts
    1

    How to access a pl sql procedure through web?

    I m a new PL SQL developer
    I was asked to create a url to access a pl sql procedure in the package which displays a web report.
    Any help on this is appreciated.
    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    The short answer is don't. If you let someone pass parameters directly into PL/SQL,
    then you will enable SQL Injection. PL/SQL should be hidden behind the front end code,
    not presented to anyone who can log into the web application.

    Just create a front end that allows the people to choose the filter they want on the report,
    validate the data and call the stored procedure. How you do that depends on what framework
    you are using. You didn't mention that, and I work only in the back end database.

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