node-oracledb
node-oracledb copied to clipboard
Not receiving CQN notifications while in Node REPL
A simple CQN example does not receive notifications when running in Node interactive REPL.
Example code is here https://gist.github.com/maxsatula/90584883001f95214e619bbd2022da08
While having successful CQN subscription, events are not coming upon table changes in REPL mode.
The same code works absolutely fine in any non-interactive mode I could think of.
> process.platform
'linux'
> process.version
'v12.14.1'
> process.arch
'x64'
> require('oracledb').versionString
'4.1.0'
> require('oracledb').oracleClientVersionString
'19.3.0.0.0'
Actually that is WSL on Windows 10 if that matters. Oracle Instant Client is used.
Database version is 11.2.0.4.0
Tried both 4.1.0 and 4.2.0 versions
Same problem. CQN subscription works when I run the script in node but doesn't work when I run it in node REPL.
> process.platform
'win32'
> process.version
'v13.5.0'
> process.arch
'x64'
> require('oracledb').versionString
'4.2.0'
> require('oracledb').oracleClientVersionString
'19.3.0.0.0'
Is this just a curio, or do you have some importance for this?
At first glance, it sounds like a REPL behavior which may be out of our control. Have you done any investigation into REPL limitations?
It is definitely not an emergency, all the time spent to figure it out has already been spent. No REPL limitations I’m aware of, all other asynchronous stuff been working well in REPL except oracledb CQN callbacks. I have a concern that a possible bug sitting at root cause of this may cause other unwanted effects outside of the discussion scope.