Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle XSLT Transformation not preserving space in text element

panksJul 29 2011 — edited Feb 26 2020
If we have a BPEL process which is calling a XSLT transformation contains the code similar as below:
for Populating an element with white space only

<tns:TargetField>
<xsl:text disable-output-escaping="yes"> </xsl:text> <!--Note the whitespace , also tried with disable-output-escaping =”no” -->
</tns: TargetField>

Our expected result / output would be:
<tns:TargetField> </tns: TargetField> <!--Note the whitespace -->

But, we get:
<tns:TargetField/>

Oracle XSLT is ignoring the white space even if we try with preserve space in XSD, or in XSLT this is not producing the expected output.


This looks a BUG with Oracle XSLT Transformation .

For a workaround solution we can use below XSLT snippet:
*<tns:TargetField>*
*<xsl:value-of select="string(' ')"/> <!--Note the whitespace -->*
*</tns:TargetField>*

This is returning Output:
*<tns:TargetField> </tns:TargetField> <!--Note the whitespace -->*



Any other work around do you find?

Edited by: panks on Jul 29, 2011 12:37 PM

Comments

thatJeffSmith-Oracle

We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(

Stay tuned…

Carl Singer

Is there a way to add a “hook” to launch into SQLcl as is done in SQL Dev or is that a future thing?

thatJeffSmith-Oracle

Sorry, not sure I understand what you mean. Can you describe in more detail what you're looking for?

Paavo

How about running sqlcl local installation in vscode Terminal window and

1.) while editing the file - select the code and use “Terminal: Run Selected Text in Active Terminal”

SQL> script
  2   ctx.write("Hello World !\n");
  3* /
Hello World !
SQL>

2.) or use the e-trick:

SQL> e hello_world.js

SQL best practice warning (2,1): G-1030: Avoid defining variables that are not used 

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.283
Elapsed: 00:00:00.052
  1  script
  2*  ctx.write("Hello World !\n");
SQL> @hello_world.js 
Hello World !
Elapsed: 00:00:00.115
1 person found this helpful
Philipp Salvisberg

We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(

Stay tuned…

IMO integrating the GraalVM scripting engine should be straightforward (I've done that for other projects). Libs compatible with Java 21 are available on Maven Central. It's sad, that in version 23.3.0 the integrated SQLcl still does not support the script command.

Any estimates on when we can expect support for the script command in the integrated version of SQLcl of SQL Developer for VS Code?

1 person found this helpful
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2011
Added on Jul 29 2011
#11g, #bpel, #business-process-management-suite, #soa-process-management
2 comments
645 views