DISQUS

noelportugal · 7 months ago

I'm trying to get Disqus to work with APEX...Right now you will have to refresh manually your browser after posting. :(

noelportugal · 6 months ago

Please share your experience installing OraTweet here. Any challenges? A breeze? Let me know!

Tess · 1 month ago

Hi Noel!
My trouble is (I suppose) the image folder on the http server.
After copied the oratweet folder into C:\oraclexe\apex\images\ the running application don "see" the javascript file
The homepage of oratweet iz without images css and javascript

In the shared components image prefix is "/i/".

tobias · 6 months ago

oratweet_apex.sql script is f500.sql in distribution

On invite page the url is only the site url, it doesn't include the [:port]/pls/apex/f?=APP_NUMBER rest of the url.
I will try modifying the SITE_VARIABLES table.

noelportugal · 6 months ago

Thanks for pointing this out! I will update the filename f500.sql to oratweet_apex.sql

The reason that the invite page is only referring to the site is because I am using the rewrite rules. So all request to http://mysite.com rewrite to http://mysite.com[:port]/pls/apex/f?=APP_NUMBER... An easy fix is to include this on the SEND_INVITE process:

oratweet_site := :SITE || :DAD || 'f?=' || :APP_NUMBER;

where :SITE and :DAD where the substitution strings defined on the application definition.

tobias · 6 months ago

Thanks, updated SEND_INVITE and it all works.
I also replaced the SEND_EMAIL UTL_SMTP calls with UTL_MAIL as I couldn't get the email working.
It now works perfectly.

Are you aware of any Twitter stand alone clients that would work with OraTweet ?

grahamcree · 6 months ago

I had issues with sending emails, to work around it I had to modify the send_auth_mail procedure to make the authentication optional i.e.

if p_username is not null then
utl_smtp.command ( l_connection, 'AUTH LOGIN' );
utl_smtp.command ( l_connection ,utl_raw.cast_to_varchar2 (utl_encode.base64_encode (utl_raw.cast_to_raw ( p_username ))));
utl_smtp.command ( l_connection,utl_raw.cast_to_varchar2 (utl_encode.base64_encode (utl_raw.cast_to_raw ( p_password ))));
end if;

tobias · 6 months ago

Those were the same issues I had.

I replaced calls to send_auth_mail with calls to send_email and changed the send_email code to keep it simple.

create or replace PROCEDURE SEND_EMAIL
( SEND_TO IN VARCHAR2
, SEND_SBJ IN VARCHAR2
, SEND_MSG IN CLOB
)
AS
pragma autonomous_transaction;



BEGIN

UTL_MAIL.send_attach_varchar2
(sender => 'oratweet@somewhere.com',
recipients => SEND_TO,
cc => null,
bcc => null,
subject => SEND_SBJ,
mime_type => 'text/html; charset=UTF-8',
attachment => SEND_MSG,
att_mime_type => 'text/html; charset=UTF-8',
att_filename => SEND_SBJ || '.html');
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'The following error has occured: ' || sqlerrm);
END SEND_EMAIL;

anjeli2001 · 6 months ago

Great Idea. I think that's exactly what we need... I'm going to install it today and get back to you with any feedback i get from my colleagues....

tobias · 6 months ago

Are any of the "stand alone clients to consume OraTweet’s timeline" available to experiment with ?
What are other people using for desktop clients?

I've looked at a python implementation, pwytter, but if there are clients that already integrate with OraTweet that would be ideal.

noelportugal · 6 months ago

Currently I do have one OraTweet client built on .net . Is not my favorite because is a little slow. Here at Oracle the "client" of choice is IM (xmpp).
Give me a few days so I can clean up the code a little and I can share it with you. Ideally we need someone to create an Adobe Air app...There are a few open source Twitter clients (Spaz) that in theory could be tweaked to use OraTweet.

-Noel

tobias · 6 months ago

The .net client sounds like a good starting point.
For linux and mac users I wonder if it would work with mono ?

How does the IM integration work (process) ?
Does the tweet become the IM status ?

How does the IM integration work (technically) ?
A java client dequeues the tweet from the table, authenticates to the IM system and updates the status ?

Patrick Miller · 5 months ago

Hi,
I am very new to use of twitter, but have a potential use of twitter for up to the minute problems that arise during go-live weekends (like of a major ERP upgrade) where we need fast communication of issues that arise so appropriate folks can work them. Having the items in the DB will help us better track these issues also.

I am trying to figure out the install of your software. We are currently using a hosted site for our Apex so I need to know which email service we need to connect to. In the configuration:
'admin@yoursite.com','PASSWORD','mail.yoursite.com',25,'ENABLED'
I am trying to figure out-- is 'yoursite.com' the email server of our Apex hosted site which needs to send/receive email --or is this our campus email server (Exchange) which resides in a different location than the hosted site? Does Oratweet need to both send and receive email?

Thanks,
Pat

noelportugal · 5 months ago

The mail address is so OraTweet can send outbound email. If you have an email account with your hosted app (ie admin@yoursite.com) you can use that one. OraTweet has a procedure to allow authenticated SMTP to be sent. By default APEX has a built in function called apex_mail.send but in order to use this you need to have your host configured to handle email...If you decide to use the default apex_mail.send you will need to modify some of the code..

-Noel

pfmnd · 4 months ago

Noel,
Do you have that sample code available if we are using the apex_mail procedure on localhost.

Thanks,
pat

Patrick Miller · 5 months ago

Thanks for the update.

Pat

pfmnd · 5 months ago

Noel,
Our hosting Apex provider states:
You can use localhost as email server and use any email address as you want. Our outbound smtp server doesn't require authentication on this server.

So in our case, what would we put in for the parameters, or do we have to use authenticated SMTP?

Pat

noelportugal · 5 months ago

I this case you could revert by using the standard apex_mail procedure that will allow you to use localhost....You will have to modify the procedures in OraTweet...Let me know if you need some sample code...

-Noel

Patrick Miller · 5 months ago

What are the current options for sending a 'tweet'? I see that you are still working on the java bot for IM. Is there an Oratweet form page which can be used to send tweets? I assume since there is an email requirement in the install that email is also an option? We currently use an Apex app for posting issues during a go-live weekend--which itemizes every major component of a go-live on an interactive report page. Would 'tweets' just be another mode of feedback? I'm trying to figure out how your app might integrate with this other Apex app -- perhaps add a page which has a report of go-live related tweets fed from the Oratweet data??

Pat

Tobias · 5 months ago

Pat, I'm interested in your go-live application. I have the same requirement for broadcast/central information communication.
Any chance of a peek at the code ?

Patrick Miller · 5 months ago

I will post a copy of it on the oracle apex hosted site where I also have an account. The version we are using has LDAP authentication to our campus LDAP which cannot be replicated at the Oracle site, so I will just make it available with a simple Apex authentication. I will post here when it is ready. If you are also interested in the LDAP integration, I can send info on the function required for that.

It is a very simple app -- shows a list of key items for go-live testing by our tech and functional users in an interactive report with status, issue and upload of files if needed for error screen prints. Uses a dial chart as a dashboard for progress. Testers can update just their test items, but can see a report of status with the overall dashboard.

Pat

tobias · 5 months ago

Pat, I'm looking forward to it.
I use APEX's LDAP integration to the corporate Active Directory and am interested in your LDAP functionality.

Very simple is great for my target audience.
I will work to get the OraTweet integrated as I have time and will provide the code if anyone wants it.

pfmnd · 5 months ago

Tobias,
I have my go-live app now uploaded to the apex.oracle.com site. Can you send me your email so I can send you login info.
My email: pmiller@nd.edu

Pat

pfmnd · 5 months ago

Noel,
Yes some sample code would be great.

Pat

pfmnd · 4 months ago

I have oratweet installed at our apex site but cannot log in to the application as a developer in my workspace.Is there an admin user for the application that has to be put in a table? The login home page comes up, but assumed like most applications that it would take the user that installed the app in the workspace as a valid user. Also, the self registration does not seem to respond. Am I missing some step in the install -- I did all that was listed in the Readme.

Also - any progress on the open source IM xmpp working with Oratweet?

Thanks,
Pat

Alexandre Pereira · 1 month ago

Hi, I have a question regarding the status update in twitter procedure you have in your code, is it still working without a problem? I'm asking because I implemented your code a few months ago and at the moment (probably it was like this since I installed but I didnt realized because no one used to tweet in Portuguese) the messages (t_messages) are being truncated by twitter, I assume this is because I'm on a nls latin-1 database and twitter waits for a utf-8 string.
Have you ever saw this problem and have some hints to solve it?

acount29 · 4 weeks ago

Hi experts.

When I logged in ORATWEET application after installation, I faced these error.
Do you know these error ?

ORA-04063: package body "ORATWEET.PKG_AUTH" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ORATWEET.PKG_AUTH"

darrylbaker · 2 weeks ago

We are trying to install OraTweet but are stuck at the following section of the instructions. Please can you provide some advice on how to proceed?

Environment
Windows 2003 server
Oracle 11g installed
App Ex installed

Enable Network Services in Oracle Database 11g
By default, the ability to interact with network services is disabled in Oracle Database
11g release 1 (11.1). Therefore, if you are running Oracle Application Express with
Oracle Database 11g release 1 (11.1), you must use the new DBMS_NETWORK_ACL_
ADMIN package to grant connect privileges to any host for the APEX_030200 database
user. Failing to grant these privileges results in issues with: