Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle BPEL Database Adapater - Passing the whole SQL itself as Parameter to DBAdapter

edited Apr 4, 2013 5:44AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
 Hi
I  need to create a BPEL process in such a way that whole sql Query should be a paramater.  How to acheive this scenario? Is that possible using DB Adapater in BPEL 11g?

Scenario

I have a select query "select * from tablename" . this query should be passed to db adapter using an assign activity.

What Operation type i need to use 
* call a stored procedure or function
* Perform an operation on table
     Insert Or update
     insert only
     Update only
     delete 
     select
     Query by example
* Poll for new or changed records in a table.
* execute pure sql



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center