PL - SQL and HTML Form Checkboxes

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

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.
http://joelennon.com/?q=pl-sql-checkboxes
  • Total Hits: 23925

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 163 votes

  • Category: Oracle/Oracle Misc

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

  • Submitted By: Shekhar

  • Set as Favorite

Description:

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 36.2%  59
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.43%  17
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12.88%  21
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.04%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.45%  48

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.






Advertisements