awsramarao/html repository overview

Sample HTML Form to Call a PL/SQL Server Page:-

Here is a bare-bones HTML form that allows someone to enter a price, and then calls the SHOW_CATALOG_PARTIAL stored procedure passing the entered value as the MINPRICE parameter.

To avoid coding the entire URL of the stored procedure in the ACTION= attribute of the form, we can make the form a PSP file so that it goes in the same directory as the PSP file it calls. Even though this HTML file has no PL/SQL code, we can give it a .psp extension and load it as a stored procedure into the database. When the stored procedure is run, it just displays the HTML exactly as it appears in the file.

Note: An HTML form is different from other forms you might produce with tools and programming languages. It is part of an HTML file, delimited by

and tags, where someone can make choices and enter data, then transmit those choices to a server-side program using the CGI protocol.

To produce a complete application using PSP, you might need to learn the syntax of , , and other HTML tags related to forms. Run using Docker :- docker run -p 80:80 awsramarao/html