Categorias
iiiiii
ver collecion desde toad o sqldevelop
Descripcion
se debe pegar ese codigo con el id de session y id
otro
DECLARE
tmp number;
v_workspace_id apex_workspaces.workspace_id%type;
v_work_id NUMBER;
vn_total number;
BEGIN
apex_application.g_flow_id := 134831;
v_work_id :=APEX_UTIL.FIND_SECURITY_GROUP_ID ('DESARROLLO');
apex_util.set_security_group_id( v_work_id);
apex_custom_auth.set_session_id(8306880671456);
select count(*) into vn_total
from TB_ENTITY TB_ENTITY
where 1 = pkg_sdf_entity.GetCountAccessClient (:P0_COMPANIA,entity) ;
--select count(*) into vn_total from apex_collections where collection_name='CUSTOMER_ACCESS';
dbms_output.put_line(vn_total);
END ;