How catch ORA-error in javascript?

User524645-Oracle

Hi!

I would like catch Oracle Db errors in my SQLcl script (wrote on JavaScript).

How I can make this?

Example:

script 

var v_xBinds = {};

if (util.execute("begin pl/sql syntax error here.  'end;',  v_xBinds)) { print(' Done.'); } else {   print('ERROR:'); }   }

/

Execution on wrong PL/SQL anonymouse block not raise any exception. How know ORA-error in script?

Thanx!

thatJeffSmith-Oracle

See the audio.js example on the GitHub project, courtesy @Kris Rice-Oracle

https://github.com/oracle/oracle-db-tools/search?utf8=%E2%9C%93&q=ctx.getProperty%28%22sqldev.last.err.message%22%29

clip.start();
16	} catch( ex) {
17	ctx.write("Error with playing sound.\n");
18	ex.printStackTrace();
…
37	cmd.end = function (conn,ctx,cmd) {
38	if ( ctx.getProperty("sqldev.last.err.message") ) {

thatJeffSmith-Oracle

If you use the Show ALL+ command, you'll also see these properties

show all+

INTERNALERRORS:

========================================

sqldev.error "false"

sqldev.error.any.in "false"

script.runner.autocommit.errorflag ""

sqldev.last.err.message ""

sqldev.last.err.message.forsqlcode ""

User524645-Oracle

Thank you!

User524645-Oracle

Hello!
Unfortunately ctx.getProperty("sqldev.last.err.message") every time return NULL.
Why?
Testcase:

script 
var v_xBinds = {};
 if (util.execute('begin pl/sql syntax error here.  end;',  v_xBinds)) {   print(' Done.'); } else {    print('ERROR:' + ctx.getProperty("sqldev.last.err.message")); }
  / 
SQL> 
@test
 ERROR:null 
SQL>

thatJeffSmith-Oracle

Did you try

sqldev.last.err.message.forsqlcode

User524645-Oracle

The same result: null. Can you please check on your enviroment? script var v_xBinds = {}; if (util.execute('begin pl/sql syntax error here.  end;',  v_xBinds)) {  print(' Done.'); } else {    print('ERROR:' + ctx.getProperty("sqldev.last.err.message.forsqlcode")); }   /