PL - SQL and HTML Form Checkboxes

Tutorials Shared by the Internet Community


PL - SQL and HTML Form Checkboxes

Because PL/SQL does not have the same support for arrays that other programming languages have, handling checkboxes in HTML forms.


  • Total Hits - 39748

  • Total Votes - 123 votes

  • Vote Up - 56 votes

  • Vote Down - 67 votes

  • Domain -

  • Category - Oracle/Oracle Misc

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 01:58:24


If you have a series of checkboxes in your HTML form and pass these to a stored procedure, that procedure may receive one of three possible types of value: a null value, a single value or multiple values. If it receives a single value (only one checkbox was checked), it will be a VARCHAR2 value. If it receives multiple values (more than one checkbox was checked), it will receive a parameter of type TABLE OF VARCHAR2. In order to handle multiple values, you must either declare a TABLE OF VARCHAR2 type or else use a predefined type, such as OWA_UTIL.IDENT_ARR.

Source Website

Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.

Broken  |   Save  |   Liked  |   Down