Oracle Public Cloud, It’s Here
More information at cloud.oracle.com.
Comments Off | Filed in Oracle | Tags: cloud, oow11Oracle ACE Director Product Briefing
Last Thursday and Friday, I, and my fellow ACE Directors, attended a product briefing at Oracle HQ. Essentially, it was a mini conference for ACE Directors organized by the ACE program team.
During these two days, Oracle product managers and SVP across different product lines shared with us the latest and greatest and what’s going to be announced next week in the areas of database, middleware and development tools.
1 Comment | Filed in Oracle | Tags: aced, oow11Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
A BLOB data type stores unstructured binary large objects. A table column with a BLOB data type can be used to store all types of files such a documents, spreadsheets, images and plain text. You can manage BLOB columns by easily adding file upload and download functionality to a form you create using Oracle Application Express (APEX).
APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
The following is a screencast to demonstrate:
- how to create a simple APEX application to store the content of any file into a BLOB column and
- how to save the content of that BLOB into a file on the database server.
I recorded the screencast on Windows 7 and Oracle APEX 4.0 that comes pre-installed with Oracle Database Express Edition 11g Release 2.
But first, here is the code that I used in the screencast:
Comments Off | Filed in Oracle | Tags: apex, howto, videoHandy Oracle Scheduler Troubleshooting Tip
This is a guest post by David Clement, a veteran database engineer and a friend of mine. You can find him online at davidclement.org.
I’ve found the following query handy for investigating an ORA-12012 in an alert log. ORA-12012 is a dbms_scheduler execution error and it provides a job number without a name, where the Scheduler views give job names without numbers. So, to relate the job number to a name:
SELECT d.job_name, d.job_action
FROM dba_scheduler_jobs d JOIN sys.scheduler$_job s
ON d.job_action = s.program_action
WHERE s.obj# = &job_number;
Maybe this will be useful for others as well.
Comments Off | Filed in Oracle, Tips | Tags: dbms_schedulerHow To Create and Use Custom Business Events in Oracle E-Business Suite
Oracle Workflow, a component of Oracle E-Business Suite, lets you set up subscriptions to business events which can launch workflows or enable messages to be propagated from one system to another when business events occur.
The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems.
Predefined events are provided with some Oracle E-Business Suite products. For example, the “Create Person Event” (oracle.apps.ar.hz.Person.create) is the name of a seeded business event in the Receivables application. The event is triggered when a person party record is created within the Trading Community Architecture (TCA).
Not all events are seeded. However, Oracle gives you the option to create a custom event. An example would be an event that is triggered when an invoice is matched to a purchase order.
In this article, I will show you how to create and use a custom business event. I will go through the following steps:
- Create a custom business event
- Create a subscription to the event
- Raise the event from PL/SQL
Consume the event in PL/SQL
Five Features You Ought to Know About the Oracle Scheduler
I really enjoyed Kscope last week. It was educational, entertaining and social. Many thanks to ODTUG and the Oracle ACE program and to everyone who made it happen.
Check out Markus‘s awesome Flickr album to get a taste of how good the conference was, especially All Aboard The Queen Mary event. 
My presentation went very well, judging from the postive feedback I got from the audience. Here is the paper that I submitted to Kscope:
Comments Off | Filed in Oracle | Tags: dbms_scheduler, kscopeSymposium Sunday at ODTUG Kscope 11
I am currently in Long Beach, California for the Kaleidoscope 2011 conference. I attended the Database Development Symposium today (Sunday), which Chet volunteered to put together. It was an all day event and it was great. Here is a very brief summary of the presentations:
2 Comments | Filed in Oracle | Tags: kscope, odtugOracle to announce big data accelerator that has something to do with Hadoop?
CEO Larry Ellison added that Oracle plans announcements around Exadata this fall, presumably at Oracle OpenWorld. It seemed like Ellison couldn’t wait to spill some of the details. He said the company plans on announcing some kind of in-memory accelerator for Exadata in the fall, as well as a big data accelerator. From how Ellison was speaking, it seemed like the big data accelerator will have something to do with Hadoop.2 Comments | Filed in Oracle | Tags: hadoop, oow11
All you need to know about the Oracle ACE program
@LydiaSmyers interviews @oracletechnet about the Oracle ACE program (via @alexgorbachev)
Comments Off | Filed in Oracle | Tags: ace, videoFor those of you keeping the faith with Oracle EBS 11i, it’s time to upgrade
Floyd Teter on Oracle E-Business Suite:
Here’s the upshot for those of you “keeping the faith” with 11i. The iceberg is melting, the curtain is coming down, the lights are dimming, the fat lady is singing. The later versions of 11i were good things…we got bundles of value out of 11i…but, like it or not, it’s winding down in favor of a better product in R12.1.3. It’s time to upgrade. Frankly, the longer you keep the faith with 11i, the more you’ll miss out on the value of the new products…and the more it will cost when you do make the move.Comments Off | Filed in Oracle | Tags: EBS
