-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|