PL - SQL and HTML Form Checkboxes

Tutorials Shared by the Internet Community

Advertisements


Synopsis

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

Statistics

  • Total Hits - 30250

  • Total Votes - 123 votes

  • Vote Up - 56 votes

  • Vote Down - 67 votes

  • Domain - joelennon.com

  • Category - Oracle/Oracle Misc

  • Submitted By - Shekhar

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

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


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements