Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oraext:query-database handle multiple nodes response

2704128Jan 16 2015 — edited Jan 20 2015

Hello I am having an issue using oraext:query-database

Error : Exception is thrown because the from-spec at line 741 is evaluated to multiple node

I am assigning

concat("select idwell as idwell from wv90.wvzonestatus where idwell =", ora:addQuotes($idwell), "and idrecparent=" , ora:addQuotes($idrec)," and status = 'PR' and upper(fluiddes) like '%GAS%' and upper(methodprod) like '%FLOWING%' and upper(typ) like '%PRODUCER%'")

to the variable $SQL

then it breaks when i try to do this

oraext:query-database(bpws:getVariableData('SQL') ,false(),false(),"jdbc/WVODI_Datasource")

and assign to a variable called $CallDB

Please advise what I am doing wrong and how to handle multiple rows returned from that SQL query.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2015

Added on Jan 16 2015

#soa-process-management, #soa-suite-discusssions

1 comment

912 views