Skip to Main Content

Java Development Tools

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!

How to call parent action from bounded task in region without rendering page fragment, immediately f

prophetNov 30 2018 — edited Dec 6 2018

Hi,

I'm trying to configure pretty simple bounded task flow in region called from page in unbounded task flow.

Idea is:

  • page in unbound flow (accessible by url in browser) contains region with this bounded task flow
  • default activity in bounded task flow is Router
  • one outcome goes to shows page fragment, another immediately calling Parent Action (which 100% exist in parent unbound task flow)

screenshots are attached below

Problem:

It works only in case of rendering Page fragment. Second case - calling Parent action - does not work. It does not redirects to another page.

More about that: In page fragment, which renders perfectly, I can place a navigation button, which calls action navigating to Parent Action - that way it works -

it redirects to proper page in unbound task flow (menuMyaccount flow case)

So as I understand it is something with "scope/phase" of bounded task flow. Can I get it working somehow?

I want to achive pretty simple goal: call parent action without rendering page fragment; router makes checks and in some cases it redirects to parent action immediately.

screenshots:

bound_task_flow.png

unbound_task_flow.png

Thanks in advance,

Artem

Comments

mNem

Works for me on 18.3... and https://livesql.oracle.com.

SQL> select banner_full from v$version
  2  /

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> ed
Wrote file afiedt.buf

  1  WITH testdata(xmlfile) AS
  2  (
  3  SELECT xmltype(
  4  '<pubDat>
  5        <bNumber>string</bNumber>
  6        <fld>string</fld>
  7        <dbInstance>string</dbInstance>
  8  </pubDat>')
  9  FROM dual)
10  SELECT
11  XMLQUERY(
12      'copy $tmp := .
13       modify replace value of node $tmp/pubDat/bNumber with "test"
14       return $tmp
15      '
16  PASSING xmlfile RETURNING CONTENT
17  ) newxml
18* FROM testdata
SQL> /

NEWXML
--------------------------------------------------------------------------------
<pubDat>
  <bNumber>test</bNumber>
  <fld>string</fld>
  <dbInstance>string</dbInstance>
</pubDat>

_jum

Both queries work fine for me too with Oracle Database 12c Standard Edition Release 12.1.0.2.0.

CarstenDD

Hello mNem,

thanks for your test and telling me where you did it. After trying different things I found out that my problem has to do with the usage of SQL-Detective as SQL-tool.

Regards Carsten

CarstenDD

Hello _jum,

thanks for your test and telling me where you did it. After trying different things I found out that my problem has to do with the usage of SQL-Detective as SQL-tool.

Regards Carsten

CarstenDD
Answer

Hello all,

the reason for the error is the usage of SQL-Detective which seems to send some strange data to the Oracle-DB. After using SQL-Developer everythings works fine. Thanks for the tester to give me the idea to change my SQL-Tool.

Regards Carsten

Marked as Answer by CarstenDD · Sep 27 2020
1 - 5

Post Details

Added on Nov 30 2018
6 comments
249 views