PLSQL_TABLE.POPULATE_BLOCK

From: bundit13_at_hotmail.com <(bundit13_at_hotmail.com)>
Date: 4 Jun 2003 16:29:37 -0700
Message-ID: <2328b42d.0306041529.12c2694_at_posting.google.com>

Hi,
  I try to populate record table in to Data Block but the browser go blank after I call the code block from trigger of PUSH BOTTON. The code below: * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * DECLARE
bk_data APPCONF_PKG.APPCONF_TBL;
v_app_id NUMBER;
BEGIN
APPCONF_PKG.DO_QUERY_BY_ID(bk_data,:APP_CONF.APPCONF_ID); PLSQL_TABLE.POPULATE_BLOCK(bk_data, 'APP_CONF'); END;
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * But If It work if I get data manualy from record table as the code below:
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * DECLARE
bk_data APPCONF_PKG.APPCONF_TBL;
v_app_id NUMBER;
BEGIN
APPCONF_PKG.DO_QUERY_BY_ID(bk_data,:APP_CONF.APPCONF_ID);
:APP_CONF.APPCONF_ID:=bk_data(1).APPCONF_ID;
:APP_CONF.CREATE_DATETIME:=bk_data(1).CREATE_DATETIME;
:APP_CONF.MODIFY_DATETIME:=bk_data(1).MODIFY_DATETIME;
:APP_CONF.LASTMODIFY_BY:=bk_data(1).LASTMODIFY_BY;
:APP_CONF.APPCONF_STATUS:=bk_data(1).APPCONF_STATUS;
:APP_CONF.APPCONF_NAME:=bk_data(1).APPCONF_NAME;
:APP_CONF.APPCONF_VALUE:=bk_data(1).APPCONF_VALUE;
END;
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Any idea?

Thanks! Received on Thu Jun 05 2003 - 01:29:37 CEST