PL - SQL and HTML Form Checkboxes
Tutorials Shared by the Internet Community
PL - SQL and HTML Form CheckboxesBecause 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 - joelennon.com
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.
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.http://joelennon.com/?q=pl-sql-checkboxes