Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » plsql web toolkit checkboxes and
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
Previous Topic: PSP - DAD configuration Error
Next Topic: Playing around with tables in HTMLDB
Goto Forum:
  


Current Time: Mon Sep 26 16:58:56 CDT 2022