5 Replies Latest reply on Aug 9, 2011 5:47 PM by csenthilmurugan

    Chat tool in application express

      Hi friends, we have created application in apex and users are accessing application using oracle user name.
      Using the same user name, we need to provide chat facility.

      Is there any option available in oracle or open source where we can integrate with some chat server or is it possible to use gmail chat facility on the same place.

      Thanks for your support.
        • 1. Re: Chat tool in application express

          You could check Openfire XMPP server

          I do not know does this help

          Br, Jari

          Edited by: jarola on Nov 9, 2009 11:27 AM

          This might help also

          You can search more from google "oracle xmpp"
          • 2. Re: Chat tool in application express
            If we have anything like http://code.google.com/p/mia-chat/ then it will be good for apex community.
            mia-chat is developed in PHP, is there anyway we can convert or execute the same in Apex.
            • 3. Re: Chat tool in application express

              Have you check that Openfire and SparksWeb ?
              I'm not sure, but it might be easy to integrate SparkWeb to Apex application.

              Br ,Jari
              • 4. Re: Chat tool in application express
                Thanks Jari, now checking on openfire with JWClient and OracleXMPP, i think, week-end this can be checked and closed.
                Checked the sparkweb, it is on flash and demo itself not working on their web site. Will update you the status by next week. Thanks for your support.
                • 5. Re: Chat tool in application express
                  Dear All, using the below program unit, we can validate mail server authentication in apex, please use the same.

                  l_ldap_host VARCHAR2(256) := 'mail.domain.com';
                  l_ldap_port VARCHAR2(256) := '389';
                  l_ldap_user VARCHAR2(256) := 'uid=user,ou=people,dc=domain,dc=com';
                  l_ldap_passwd VARCHAR2(256) := 'password'; --user password

                  l_retval PLS_INTEGER;
                  l_session DBMS_LDAP.session;
                  l_attrs DBMS_LDAP.string_collection;
                  l_message DBMS_LDAP.message;
                  l_entry DBMS_LDAP.message;
                  l_attr_name VARCHAR2(256);
                  l_ber_element DBMS_LDAP.ber_element;
                  l_vals DBMS_LDAP.string_collection;

                  -- Choose to raise exceptions.
                  DBMS_LDAP.USE_EXCEPTION := TRUE;
                  -- Connect to the LDAP server.
                  l_session := DBMS_LDAP.init(hostname => l_ldap_host,
                  portnum => l_ldap_port);
                  l_retval := DBMS_LDAP.simple_bind_s(ld => l_session,
                  dn => l_ldap_user,
                  passwd => l_ldap_passwd);
                  DBMS_OUTPUT.PUT_LINE('bind:L_RETVAL: ' || l_retval);
                  l_retval := DBMS_LDAP.unbind_s(ld => l_session);
                  DBMS_OUTPUT.PUT_LINE('unbind:L_RETVAL: ' || l_retval);