first make select list item P2_AUTHENTICATION_ID
that will contain all Authentication available for your APP
use this code as source
select name as d,
id as r
from APEX_200200.wwv_flow_authentications
where flow_id = :APP_ID
and security_group_id = :WORKSPACE_ID
order by 1
UPDATE APEX_200200.wwv_flows
SET AUTHENTICATION_ID =:P2_AUTHENTICATION_ID
where ID = :APP_ID;
--
thanks
عندى مشكلة فى الكود على ال Oracle Cloud
ردحذفSELECT * FROM WWV_FLOWS
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 1 Column: 13