Hello World with Oracle PL/SQL

Hello World with Oracle PL/SQL. The most boring blog entry, ever.

  Obi-Wan: "These aren't the droids you're looking for."

  Agent Kay: "Nothing to see here. Move along folks."

set serveroutput on;

-- Drop package body hw;
-- drop package hw;

   PROCEDURE hello_world;
END hw;
  PROCEDURE hello_world
    hw_str VARCHAR2 (more...)

B2B 12c – What’s New! by Tiago Teixeira

clip_image002This post serves as the first of a series of posts dedicated to Oracle B2B. What better way to start this series than to highlight the many new features have been added to Oracle B2B 12c which can change the landscape of the target usage for B2B.
Let's look at some of these new features:

· Document Translation Callout Framework

o Introduced Document Callout for custom document parsing (inbound), validation and construction (outbound)

· Regular (more...)

JpsAnonymousRoleImpl Issue for Custom Login page Using Managed Bean in ADF by Rohan Walia


While implementing Custom Login page using Bean Custom Login Page using Login Bean in ADF, once you do all the steps and run the login you get a nasty exception below:
This example was created using Jdev

oracle.security.jps.JpsException: java.lang.IllegalArgumentException: oracle.security.jps.internal.core.principals.JpsAnonymousRoleImpl

Hmm we did all the steps correctly but face this exception while running the CustomLogin Page.
So while troubleshooting (more...)

April 30 Developer Cloud Service Live Webinar with Q&A

Developers of all stripes are moving applications and tasks to the cloud. But with that move comes a lot of considerations; how to test in this new environment, how to collaborate with other developers, how to manage on-premise applications from the cloud... and the list goes on.

We are excited to announce recent enhancements to Oracle Developer Cloud Service, designed to make life easier for developers; we help you streamline the entire development process and (more...)

Oracle Sustainability Innovation Awards – Nominations Now Open

Nominations are now open for the 2015 Oracle Sustainability Innovation Awards, part of the Oracle Excellence Awards. These awards recognize customers and their partners who are using Oracle products to take an environmental lead as well as to reduce costs and improve business efficiencies using sustainable business practices. For example, a customer may use Oracle’s Agile Product Lifecycle Management to design more eco-friendly products, Oracle Cloud Solutions to help drive down power consumption, Oracle Transportation (more...)

Oracle Alta UI Design Philosophy In Focus

Oracle Alta UI has much to offer as a design system and philosophy. It's mobile first approach is backed up with patterns, development tools and more.When we talk about Oracle Alta UI as a design system, a philosophy, and even when we talk about Oracle Alta UI patterns [browser | mobile] we are often talking about generalized concepts. There is nothing quite like a discussion of these concepts thoughtfully framed around a (more...)

Are You Considering Item Web Services for Oracle Product Hub?

Need information on the different item web services available for Oracle Product Hub? Yes? Then we bet your concerned about extracting Product Hub item and structure information because of the complexity of item attributes. Your probably especially concerned if you have a large number of user-defined attributes (UDA's). No Worries. The Inventory Social Media team will again be a beacon.

Oracle Product Hub provides web services for publishing and integration to other external systems, and (more...)

New Bundle Patches for SOA, SOA and OSB

New Bundle Patches for SOA, SOA and OSB were released on April 14,2015:

Product Version

Bundle Patch Name

Bundle Patch Number



Bundle Patch 7 (

Patch 20423535


Bundle Patch 2 (

Patch 20423408


Bundle Patch 4 (

Patch 20423630

For more information please refer to the following notes:

  1. Note 1485949.1 SOA 11g: Bundle Patch Reference
  2. Note 1499170.1 OSB 11g: Bundle Patch Reference

Java in the Trenches

Java has been driven into the trenches, some years ago already.

More or less the general consensus appears to be that the frontend battle has been won by JavaScript.

So, what's the role for Java in this brave new world? More or less the general consensus appears to be that Java has great value on the backend. The Java EE Platform is awesome in that it consists of specifications agreed upon across the industry, whereas (more...)

Friday Spotlight: The Power of The Ksplice Feature of Oracle Linux Video

Happy Friday!

I'm really excited to share this week's Friday Spotlight with you. Oracle Senior Vice President of Linux and Virtualization Wim Coekaerts sat down with Director of Product Management Michele Casey and Senior Development Manager Jamie Iles to talk about Ksplice.

In the video, they go into a lot of detail about why Ksplice is a production-ready tool for keeping systems up to date. A highlight for me is the discussion featuring a real (more...)

Java Magazine New Edition

Want to know how to optimize Java performance, whether your applications are in a cloud environment or on the JVM?  

In this new edition, Kirk Pepperdine examines parallelism using the fork/join framework to boost performance. Michael Heinrichs, in “The Quantum Physics of Java,” looks at modern chip design and its effect on Java programs. Chris Newland discusses the effects of small source code changes and Java HotSpot VM switches in Java just-in-time (JIT) (more...)

Having Trouble Publishing Projects?

Because the P6 Extended Schema is the lifeline of data for Primavera Analytics it is an important topic to cover.
There are two white papers which go into depths about the feature, how to setup, how it works, and some advanced configurations and techniques.



The key to having project publish is a job service called the Arbiter. If you query the jobsvc table as admuser you will (more...)

The Intersection of “Data Capital” and Advanced Analytics

We’ve heard about the Three Laws of Data Capital from Paul Sonderegger at Oracle: data comes from activity, data tends to make more data, and platforms tend to win. Advanced analytics enables enterprises to take full advantage of the data their activity produces, ranging from IoT sensors and PoS transactions to social media and image/video. Traditional BI tools produce summary data from data – producing more data, but traditional BI tools provide a view of (more...)

CPU Efficient Query Processing with Database In-Memory

In my last post I talked about In-Memory Aggregation and mentioned that the vector transformation plan is more CPU efficient than alternative plans.  In this post I’ll provide a few examples to illustrate just how effective a vector transformation plan can be.

Let’s consider a star schema, with one fact table and 9 dimension tables (time, customer, product, channel and demographic attributes such as age and income).

9 Dimensional Star

 All tables have been marked INMEMORY MEMCOMPRESS FOR (more...)

Oracle VM Trainings in Hyderabad

This evening, I completed a back to back OU classroom training program on Oracle VM for x86 and Oracle VM for SPARC in Hyderabad.

To know more details about the Oracle University offerings around Oracle VM, click here. Official documentation on Oracle VM can be found here.

UK Special: Modern Business Summit, London 28-30 April 2015

We have a brilliant line up of speakers for our Modern Business Summit in London. The agenda includes customer case studies and sessions with CX experts. Which sessions are you most interested in? http://ora.cl/Kj6

Survival In A CX-Centric World- Forbes article

Deliver or else: survival in a CX-Centric World http://ora.cl/MkI

Productivity – A Priority for Every Business Leader by Caesar Peter

Oracle CloudWorld was held on the first week of April in India. Interestingly, the summit coincided with the new financial year in India and hence performance strategy was top of mind for almost every business leader with whom I met.

Generally, the most popular discussions during these events are about setting a higher sales budget, IT application, project status, economy, etc. On contrast to this popular approach, it was wonderful to note that most of (more...)

Friday Spotlight: Oracle OpenWorld Call For Proposals

Happy Friday!

The Oracle OpenWorld 2015 Call for Proposals is now open. Attendees at the conference are eager to hear from experts on Oracle business and technology. They’re looking for insights and improvements they can put to use in their own jobs: exciting innovations, strategies to modernize their business, different or easier ways to implement, unique use cases, lessons learned, the best of best practices. If you’re an Oracle technology expert, conference attendees want to (more...)

Customers Share Business Benefits of using Oracle Exalogic Elastic Cloud

Many satisfied Oracle Exalogic Elastic Cloud customers are enthusiastically sharing their success stories, and we are proud to pass them on. Here are a few of the more recent testimonials on how Exalogic is helping to solve business problems. Key highlights are mentioned below; more details are included in each of the stories.


Cognizant is managing their explosive growth with Exalogic, Exadata, Peoplesoft, Enterprise Manager, and ACS for a 65% reduction in processing time (more...)