Oracle Forms (MOSC)

MOSC Banner

connect to portal from form

edited Feb 12, 2013 5:08AM in Oracle Forms (MOSC) 1 commentAnswered
The following is portion of creating sso account in oracle form 10g. It does not work, no error mesasge but nothing crerted in SSO DB.

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center