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.
Note: As mentioned in the comments, there are two other ways to accomplish connectivity between the host and the guest VM: NAT with port forwarding and host-only adapter. This article assumes that networking between the host and the guest is done via a bridged adapter.7 Comments | Filed in Oracle | Tags: howto, virtualbox
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).
The following is a screencast to demonstrate:
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, video
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:
Consume the event in PL/SQL