The syntax is documented here. I highlighted the relevant part in the following image:
The following code worked in 23.3. In 23.4 it reports a compile error: “PLS-00881: missing closing delimiter 'q'[return' for MLE language code”.
create or replace function to_epoch_js2("in_ts" in timestamp)
return number is
mle language javascript q'[return in_ts.valueOf();]';
/
I tried various variants of quoted string literals (e.g. q'~…~') but nothing works. IMO also a normal string such as '…' should work as long as the JavaScript code does not contain apostrophes.
However, in 23.4 MLE Inlined Call Specifications do not work anymore.
I hope this can be fixed in one of the coming versions.
Thank you.