Hello everybody,
I have script to create workspace, scheme and user it should work work perfectly and it does, but only if I run it in Database Actions (web sqldeveloper). But if I run it via any local client SQLplus/sqlcl/sqldeveloper it script doesn't make APEX user. apex_util.create_user is executed successfully, but there is no there is no sign about this user in APEX. What did i miss here?
I uploaded the script here: https://livesql.oracle.com/apex/livesql/s/og0xq4ed96dmtyvazp69xkwas (I know maybe it's not the best place)
Thank you, Tim