PL - SQL and HTML Form Checkboxes
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: 5614
Total Votes: 36 votes
Category: Oracle/Oracle Misc
Submitted on: 2008-04-15 01:58:24
Submitted By: Shekhar
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 |
|---|---|---|
![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |





16.67%

16.67%

16.67%

16.67%

16.67%