begin
wwv_flow_api.set_security_group_id(p_security_group_id=> 10173232444632225 );
end;

declare
val number;
begin
val := HTMLDB_UTIL.FIND_SECURITY_GROUP_ID (p_workspace=>'MyWorkspace');
wwv_flow_api.set_security_group_id(p_security_group_id=>val);
end;

sqlplusw /nolog

SQL*Plus: Release  10 . 2 . 0 . 1 . 0  - Production on Ср Авг  8   14 : 56 : 48 

Copyright (c)  1982 ,  2005 , Oracle.  All rights reserved.

SQL> connect flows_030000
Введите пароль: ******
Соединено.
SQL> @test.sql
Creating workspace TEST...
Creating Groups...
Creating Users...
...done
SQL> @f103.sql
APPLICATION  103  - Тест
Set Credentials...
Check Compatibility...
API Last Extended: 20070108 
Your Current Version: 20070108 
This import is compatible with version:  20070108 
COMPATIBLE (You should be able to run this import without issu
Set Application ID...
...authorization schemes
...navigation bar entries
...application processes
...application items
...application level computations
...Application Tabs
...Application Parent Tabs
...Shared Lists of values
...Application Trees
...page groups
...comments: requires application express  2 . 2  or higher
...PAGE  0 : Zero
...PAGE  1 : Page  1 
...PAGE  100 : Manage Users
...PAGE  101 : Login
...PAGE  102 : Reset Password
...lists
...breadcrumbs
...page templates for application:  103 
......Page template  1080229215061906 
......Page template  1080307444061915 
......Page template  1080412554061915 
......Page template  1080502342061917 
......Page template  1080627803061917 
......Page template  1080703683061917 
......Page template  1080817239061917 
......Page template  1080928253061917 
......Page template  1081032336061917 
...button templates
......Button Template  1081125402061917 
......Button Template  1081205298061920 
......Button Template  1081315760061920 
......Button Template  1081426297061920 
...region templates
......region template  1081509083061920 
......region template  1081614200061923 
......region template  1081717958061925 
......region template  1081806661061925 
......region template  1081916698061925 
......region template  1082002536061925 
......region template  1082101003061925 
......region template  1082204048061925 
......region template  1082311688061925 
......region template  1082429447061925 
......region template  1082516531061925 
......region template  1082623837061925 
......region template  1082700579061925 
......region template  1082820665061925 
......region template  1082926508061925 
......region template  1083013719061925 
......region template  1083102620061925 
......region template  1083221276061925 
......region template  1083330728061925 
......region template  1083412297061925 
......region template  1083514376061925 
...List Templates
......list template  1083616680061925 
......list template  1083716715061931 
......list template  1083827163061931 
......list template  1083921483061931 
......list template  1084025222061931 
......list template  1084121810061931 
......list template  1084226446061931 
......list template  1084327874061931 
......list template  1084402733061932 
......list template  1084523813061932 
......list template  1084618234061932 
......list template  1084723632061932 
......list template  1084800323061932 
......list template  1084915486061932 
......list template  1085012040061932 
...report templates
......report template  1085125611061932 
......report template  1085217331061937 
......report template  1085312057061937 
......report template  1085400555061937 
......report template  1085513671061937 
......report template  1085623562061937 
......report template  1085719358061937 
...label templates
......label template  1085818019061937 
......label template  1085927747061939 
......label template  1086018712061939 
......label template  1086106637061939 
......label template  1086220211061939 
...breadcrumb templates
......template  1086319219061939 
......template  1086413252061940 
...popup list of values templates
......template  1087103223061945 
...calendar templates
......template  1086509994061940 
......template  1086716717061945 
......template  1086917256061945 
...application themes
......theme  1087229964061946 
...build options used by application  103 
...messages used by application:  103 
...Language Maps for Application  103 
...Shortcuts
...web services (9iR2 or better)
...shared queries
...report layouts
...authentication schemes
......scheme  1087322394061964 
......scheme  1177606713819281 
...done
SQL>