↓
 

EvROCS

Completing the puzzle

  • Home
  • Evenementen
    • = Lijst van evenementen =
    • KScope
      • KScope Algemeen
      • KScope15, Hollywood Florida
      • KScope14, Seattle
      • KScope13, New Orleans
      • KScope12, San Antonio
    • Kerstmis 2013
    • OPP 2007
  • CV
  • Quotes
  • Contact
  • EScope
  • Downloads
    • Query KScope Sessies
  • Blog
Home→Tags Custom

Tag archieven: Custom

Your library is your paradise

EvROCS Geplaatst op 2021-05-28 door Erik van Roon2023-10-10

Update 14-07-2021 I just tried SQLcl latest version 21.2. First results: The registering of my custom commands with below library doesn’t work anymore. Could be my bad, in which I’ll try to fix it, could be something in SQLcl. I don’t know yet, have to investigate as soon as I have the time. For now: Either don’t use this library, or stick to 21.1.1 until the root cause is fixed. Update 08-10-2021The above mentioned problem was not due to my code, so the library can be safely used. It’s caused by new stuff inside SQLcl.So, if you run javascript code and only receive one of these messages:“!ScriptCommand.1!”“JS Language engine not found”The quickest way to solve it is to install JDK. (Or better yet: GraalVM. See next update.) Update 14-04-2022On 07-04-2022 version 22.1 of SQLcl was released which ends support for Java 8.So, as of that version Java 11 is the … Lees verder →

Geplaatst in Geen categorie | Getagged Command, Custom, Custom Command, Extend, JavaScript, library, register, Scripting, SQLcl, unregister | Geef een reactie

Hit the road Jack, and don’t you come back no more….

EvROCS Geplaatst op 2021-05-28 door Erik van Roon2021-05-28

In my blogpost “Being in command“, about custom commands I said that I couldn’t find a way to unregister  a registered custom command, other than restarting SQLcl.That is still true. I couldn’t.But Philipp Salvisberg could. He was able to find a way to do just that. That means that with his hard work as input, we are now able to Unregister a previously registered custom command.That makes it possible to register the command in an edited new version without the need to restart SQLcl. So, like Jack in the famous song, let’s try to kick a registered custom command out of our SQLcl house. Go straight to Introduction First of all: this post will deal with the code needed to unregister a custom command.In my humble opinion just, like registering a command, it takes too much code and effort to be considered user friendly.In my next blog post I will … Lees verder →

Geplaatst in Geen categorie | Getagged Command, Custom, Custom Command, Extend, JavaScript, register, Scripting, SQLcl, unregister | Geef een reactie

Being in command

EvROCS Geplaatst op 2020-08-19 door Erik van Roon2021-05-28

This post is the third one of three that together are an introduction to scripting in SQLcl.Also read part 1 and part 2. In the previous post I’ve created functionality for SQLcl that it doesn’t have “out of the box”.In this post I’ll continue to build on that script, but the information here is valid for any JavaScript script you develop for SQLcl. In short: I built some functionality in JavaScript that can read a client file and place the contents in a bindvariable.This script resides in a file called “file2bind.js” so we can use it by telling SQLcl we want to run a script with this name and certain parameter values.Executing that script is done using the built in command “script” As I’ve said a couple of times in that post: I’m lazy.So typing “script ” every time I want to execute this script will get on my nerves … Lees verder →

Geplaatst in SQLcl | Getagged Alias, Command, Custom, Custom Command, Extend, JavaScript, Listener, Scripting, SQLcl | 3 reacties

Talen

  • Nederlands
  • English (Engels)

Zoeken

Subscribe for notification of new blogposts

Subscribe to email notifications for new blog posts

Loading

RSS

  RSS Feed Blog Posts

  RSS Feed Comments

Recente berichten

  • It’s so easy to pick the wrong one                                         #JoelKallmanDay
  • Your library is your paradise
  • Hit the road Jack, and don’t you come back no more….
  • Being in command
  • A Person who won’t read has no advantage over one who can’t read

Follow me on Twitter

Erik van Roon Volgen

Oracle DB Dev Oracle ACE Pro ♠️ Symposium42 Rambling fool By default assume I'm not serious Tweeted opinions are the one & only truth, and probably unfounded

evrocs_nl
Retweeten op Twitter Erik van Roon Geretweet
poug_org ORA-600 @poug_org ·
vr 2025-04-25 09:03

It's time to break the silence. #POUG2025 is not just a fun conference. It can be dangerous.
@evrocs_nl Van Roon was the first to speak loudly about the consequences of attending our event.
https://poug.org/edycja/poug-2025/

Retweeten op Twitter Erik van Roon Geretweet
ora600pl Kamil Stawiarski @ora600pl ·
za 2025-04-12 14:10

Who wants to simulate OCI on premises to play with 23ai at home?

https://blog.ora-600.pl/2025/04/12/simulate-oracle-cloud-on-kvm-olvm/

Retweeten op Twitter Erik van Roon Geretweet
poug_org ORA-600 @poug_org ·
vr 2025-04-04 10:06

Vergiss langweilige Konferenzen mit Verkaufsmaschen und null Mehrwert 🙄

Komm zu einem 100 % Tech-Event direkt hinter der Grenze - und werde Teil einer einzigartigen Community. #POUG2025 wartet im September auf dich! 🔥

https://poug.org/en/

evrocs_nl Erik van Roon @evrocs_nl ·
do 2025-03-20 16:02

#APEXWorld25 by @nl_OUG
One of the wonderful events that values new speakers and thus actively advertises for the @mashprogram
Thanks guys!

Retweeten op Twitter Erik van Roon Geretweet
nl_oug nlOUG @nl_oug ·
vr 2025-03-14 09:00

On March 20, we will celebrate 15 years of APEX World with an evening of entertainment. Prepare for an evening to remember! You just might win a prize!

Get your tickets for APEX World so you can join in on the fun! https://nloug.nl/events/apex-world-2025/

#orclAPEX #aw25

Load More...
©2025 - EvROCS - Weaver Xtreme Theme
↑