It's not a shame, just a bug. I'm pretty sure this was working before, so it's not a deliberate omission.
1 person found this helpful
As Jeff suggests, if you revert to an older version of SQLcl, say sqlcl-22.214.171.124.349.0706-no-jre from mid-December, the test case works.
1 person found this helpful
FYI: I find that it works with "&&" as opposed to "&" within the context of a single SQL file. Called SQL files appear to lose anything defined with new_value as reported here: SQLcl: new_value and @: variable defined by new_value in caller script is unknown in called script
Thanks all for the feedback.
Confirmed. Just tried this on the dec 15 version, and it works there.
@RJLyders : Thanks for the workaround. But I have several 'utility' scripts that get information and put it in variables, so these scripts can be called by other scripts that need this information. So these won't work, even with the workaround.
I guess I'll just have to wait for the next version (previous one had other issues for me).
Still the tool is becoming more and more awesome.
Can't wait for the day I can make a 100% transition (I'd even be prepared to rewrite some of my scripts if needed).
Where did you get the Dec 15th version? I was about to log this new_value issue, but found this thread... I'd like to have it working until it is patched.
Well, clicking on the Previous Version link on the line of the 4.1.3 Downloads page that says Troubleshooting - Previous Version should work, but unfortunately that will take you back to the 4.1.1 release page which lists the Oct 13, 2015 version of SQLcl.
So unless someone else knows where to find that standalone version, your best bet is to download the full SQL Developer 4.1.3 which includes that version of SQLcl and use that. For convenience, you may wish to copy the relevant jar files from there, replacing the newer ones in your standalone SQLcl version's lib directory.
I got it from the standard location somewhere between dec 15 and feb 18
But I guess the real question you're asking is: ""where can I get it now?".
I always keep the old versions of my software, so....
I am perfectly happy to provide you a link to that version on my personal storage.
However, I am not 100% sure that by doing so I wouldn't be making Oracle unhappy.
I know it's free stuff, but still, to download the software you need an otn account and need to accept the terms and conditions.
Giving you a download link to my downloaded software bypasses this all together.
So, if someone (Jeff???) could convince me I wouldn't be doing illegal stuff, I'll post a link.
Since you asked, I have to reply, no, you shouldn't be doing that. And if you do do it, don't talk about it here.
The real solution will be posting an update with this, and many other bugs fixed. Stay tuned.
That's what I feared.
And that's the problem with asking: now I can't say "Sorry, didn't know" anymore
Anyway, Richard, I think we just need to wait a little more. Probably not too long.