connect to portal from form
I could create manually with same package procedures. create_users.portal_create_user, RAD_MANAGER
--------------------------------------------------------------------------------------------------
begin
connection_id := EXEC_SQL.OPEN_CONNECTION('portal', v_portal_pass, v_portal_db);
exception
when exec_sql.package_error
then std_send_alert('Connection to OID database failed. Unable to programmatically create OID record.','S',TRUE);
end;
-- confirm connection to database
bIsConnected := EXEC_SQL.IS_CONNECTED(connection_id);
if not bISConnected
then std_send_alert('No present connection exist to OID database. ','S',TRUE);