(Donal Daly) We have updated the early adopter release of Oracle SQL Developer Migration Workbench today on OTN. You can get it from here. This is our final preview release, before we go production. We are now functionally complete for this initial production release and are now focused on fixing ou

(Rudy Limeback) I would like to find out how long a particular customer order has been on hold. The current system allows the status of an order to be placed on hold which gives me the beginning date via the history timestamp. Unfortunately, the only action I can take next is to change the status to

(Patrick Sinke) The changelog of Apex 3.0 mentions something about featuring shuttleboxes. Don’t get too enthousiastic, you still have to do a lot of work yourself. And it’s pretty limited, because this feature assumes the use of static values. That’s not what we want! We want dynamic information fr

(Byte64) If you worked with version 8i, you probably remember the initialization parameter JOB_QUEUE_INTERVAL.

(Alex Gorbachev) One of our clients had an ORA-1555 “snapshot too old” error two nights in a row. The quick and dirty fix would be to increase the retention_period and the potential size of the UNDO tablespace.

In this article, we will be presenting a systematic methodology and best practices for managing a highly secure Oracle E-Business Suite environment. The attendees will come out understanding how to secure all aspects of the E-Business Suite technology stack. We will present how to secure the data c

(Mark Brunelli) Oracle has announced plans to acquire Agile Software Corp., a maker of product lifecycle management (PLM) software, in an all cash deal worth $495 million. (R)

(Bob Watkins) One of the trickiest parts of Oracle’s security model is the way that roles (collections of database privileges) interact with stored procedures, functions, and packages. Object privileges in Oracle can be granted directly to the user or indirectly via a role.

(Lucas Jellema) With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way too much time on pretty nonsensical exercises like the Gauge and Stacked Bart Chart in SQL, I had decided not to do it a

(John Charles Olamendy) This article will illustrate how to send binary data from Windows Communication Foundation (WCF) to Oracle Application Server (Oracle AS) using Web Services specifications specifically MTOM standard specification, thus achieving interoperability between the two platforms. Som