How to Connect to Oracle Database on a Guest VM from the Host
Here is the set up: The host is a Windows 7 machine, 64 bit with Oracle client. the guest is a Windows XP Virtualbox VM running Oracle Database 11.2.0.2. All default installations and configurations.
You want to be able to connect to the Oracle database (SQL*Plus, SQL Developer, TOAD…) from the host.
Here is what I did to enable Oracle TNS connection between the host and the guest.
2 Comments | Filed in Oracle | Tags: howto, virtualboxCreate 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, videoHow 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
