Description
I am working on a project with your node-odp. there are some issues I have met so far.
1, scalar and reader
sql1 = select count() from a_table where xxx
sql2 = select count() as amount from a_table where xxx
when use scalar to run sql1, get nothing. if use reader to run sql2, you always get amount
2, catch error
my app loads records from oracle into mongodb. reader is used. problem is when error occurs (for instance, ora - xxxxxx, say SELECT TO_DATE("Column", 'mm/dd/yyyy') as ADATE FROM a_table but actually '2013-01-01' in the "Column", this causes a conversion error), this error can not be caught. In this case, what my app wants is just ignores the error and works on next row. BUT there is no way from crashing the app.
3, charset
Any other tools I use to get data from Oracle correctly deal with UTF8 chars such as Chinese characters, but node-odp does not. Is there a way to deal with charset?
I may do something wrong??? Need help! Thanks!
Gavin
Activity
bomsy commentedon Jun 19, 2013
reader: the reader returns rows or rowsets so to get your count value use
i'm working on getting errors to be thrown through the error, update soon.
I'm not consiously dealing with charsets at the moment, but i'm looking into it based on your issue. Update soon.
Thanks
wuyongfei commentedon Jun 19, 2013
Thanks a lot Bomsy!
fmatosinhos commentedon Feb 19, 2014
Hi guys,
Did you solve the problem: "2, catch error"?
Could you give me the solution?
Thanks a lot