PL - SQL and HTML Form Checkboxes

Tutorials Shared by the Internet Community


  Top Tutorials     New Tutorials     Submit     Login     Register  

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: 29221

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 169 votes

  • Category: Oracle/Oracle Misc

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

  • Submitted By: Shekhar

  • Set as Favorite


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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 35.5%  60
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.65%  18
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 13.02%  22
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.24%  19
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.59%  50

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.