Questions tagged [ora-02290]
2 questions
3
votes
1 answer
Oracle DML errors lacking detail
I am catching errors from a bulk insert operation like this:
begin
--bulk insert
forall i in v_data.first .. v_data.last save exceptions
insert into my_filter_table values v_data (i);
commit;
exception
-- catch and print…
FrustratedWithFormsDesigner
- 26,726
- 31
- 139
- 202
1
vote
2 answers
What's the right way to handle UTC date-times using Java, iBatis, and Oracle?
I'm coming up against an unexpected daylight savings time problem in code I thought was purely UTC. I'm using Java 1.6, the iBatis SQL mapper (2.3.3), and Oracle XE (an eval version of Oracle 10.2) with the Oracle thin driver.
The database contains…
Jim Ferrans
- 30,582
- 12
- 56
- 83