| plsql web toolkit checkboxes and [message #47850] |
Thu, 23 September 2004 13:17 |
Brian Schoudel
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
I have a plsql table in the header of a package procedure of the form:
TYPE EnabledTab IS TABLE OF VARCHAR2(1);
My procedure header is:
PROCEDURE P_ControlSessions( setInt NUMBER DEFAULT NULL,
setRec NUMBER DEFAULT NULL,
setDBcon NUMBER DEFAULT NULL,
complete VARCHAR2 DEFAULT NULL,
ssRoleTable EnabledTab DEFAULT EnabledTab('*') )
I'm building a dynamic list of checkboxes in which I want to submit the plsql table into the procedure above. Here is my loop that builds the checkboxes and populates the ssRoleTable table and then submits into P_ControlSessions:
FOR v_ui2ssroledata IN t_ui2selfservicerole_grab LOOP
twbkfrmt.p_tablerowopen;
countSSRoles := countSSRoles + 1;
v_table1(countSSRoles) := v_ui2ssroledata.enabled_ind;
twbkfrmt.p_tabledatalabel(cvalue=>v_ui2ssroledata.description, cnowrap=>'nowrap');
twbkfrmt.p_tabledata (cvalue=>htf.formcheckbox (cname => 'ssRoleTable' ,cvalue=>v_table1(countSSRoles)
,cchecked=>v_ui2ssroledata.checked_ind));
twbkfrmt.p_tablerowclose;
END LOOP;
where v_table1 is of type EnabledTab.
This package compiles fine but I get an error everytime I try to submit this html form.
[[Thu Sep 23 16:07:24 2004]] [[error]] [[client 130.126.239.141]] [[ecid: 1095973644:64.22.186.131:31517:0:606,0]] mod_plsql: /BANDEV/tzbkwgov.P_ControlSessions HTTP-404 ORA-06550: line 10, column 2:
PLS-00306: wrong number or types of arguments in call to 'P_CONTROLSESSIONS'
ORA-06550: line 10, column 2:
PL/SQL: Statement ignored
I haven't been able to get this working right. Any help would be appreciated.
Thanks,
Brian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
