search

hashhashu / sqltools-Oracle-driver

SQLTools Driver for Oracle
MIT License
4 stars 1 forks source link

EXEC not supported? #2

Closed MagnusMG closed 1 year ago

MagnusMG commented 1 year ago

I tried to execute a procedure using EXEC, and got the error message 'ORA-00900: invalid SQL statement'. When I changed to CALL it worked. (Both versions work fine in SQL Developer.)

Working:

CALL drop_table('MyTable');

Not working:

EXEC drop_table('MyTable');
hashhashu commented 1 year ago

Yes, it hasn't supported right now, I will add it later. Thanks.

hashhashu commented 1 year ago

Hi, beacuse the node-oracledb dosen't support the exec key word, I replace exec with call before processing.

MagnusMG commented 1 year ago

Great! Thanks!