Closed YMS-QC closed 3 months ago
Please:
Include a runnable Node.js script that shows the problem.
ok ASAP
@cjbj runnable Node.js script that shows the problem is uploaded,plz take a look .
If we understand correctly what you are asking, our current thoughts are that this is an Oracle Client bug. Ideally we think you should get an ORA error when you try to use data that is too long. We'll report it to the OCI team so they can make this happen.
For Thin mode (which I know you personally can't use), we will look at seeing if we can add a similar check.
thank you ,I am trying to use json schema to validata data before using procedure now
@YMS-QC We have added a patch here that will throw an error, when you use attributes values in dbObject that are too long.
This will be officially incorporated in the 6.4 release
thank you very much !!!
This has been fixed as part of node-oracledb 6.4
node-oracledb version 6.2.0 oracle 11.2 instantClient 19.21
when i use getObjectClass function creating dbObjects, one of it's nested objects can not be initialized ,because one of it's attribute(varchar2) should be shorter than 30 bytes but given 120 length data, AND no error was thrown.
when object was inited with invalid data then
TBL
table object is empty ,here is an example script to show the issue,to run this script ; the user should have all privileges to create types and procedures.
you should get console log results below![Snipaste_2023-12-02_22-57-36](https://github.com/oracle/node-oracledb/assets/70993229/c8a57614-8d2e-4390-a987-16c4871530fa)