Skip to Main Content

APEX

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!

Branching issue with 20.1.0.0013 - Error: SyntaxError: JSON.Parse ....

PJJun 11 2020 — edited Jun 11 2020

Hi There

Just wondering what is the issue here. I am trying to create a conditional branch using this?

<code> -- can someone please tell me how to markup code in here ....

 declare

   l\_client\_type   varchar2(80);   -- branching logic will be based on this

   l\_redirect      varchar2(80);

   l\_page\_no       pls\_integer  := 4020

 begin

   l\_redirect := 'f?p='|| v('APP\_ID') ||':'||l\_page\_no||':'|| v('APP\_SESSION');

   PLJ\_LG.D(l\_redirect);     -- capture in log to test, and yes it works fine ......

   owa\_util.redirect\_url(l\_redirect);

   apex\_application.stop\_apex\_engine;

 end;

</code>

When I run this I get:

branch-error.png

Note that if I cut and paste the generated string from the log file and paste it into the location bar - if redirects fine ....

Thank you

Paul

This post has been answered by Keyser on Jun 11 2020
Jump to Answer
Comments
Post Details
Added on Jun 11 2020
9 comments
958 views