Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problems catching Overflow 1426 jdbc

 
   Database Help (Home) -> Oracle RSS
Next:  HOw to introduce a proactive approach on DB use?  
Author Message
Carsten Broschek

External


Since: Oct 11, 2008
Posts: 1



(Msg. 1) Posted: Sat Oct 11, 2008 3:25 am
Post subject: Problems catching Overflow 1426 jdbc
Archived from groups: comp>databases>oracle>misc (more info?)

Hi,

during an simple INSERT into table in a stored function,
a ORA 1426 is raised. Thats OK, I already identified the
column that is exceeded.
I am surprised about the fact, that if I trigger my
stored function from sqlplus, my pl/sql routine catches
the exception and returns properly. The same trigger from
out an java-application via jdbc, seems not to catch
the overflow, does not end and I retrieve sqlexception
because of closed connection later on.

Snippet from pl/sql:

[...]
EXCEPTION
WHEN OTHERS THEN
BEGIN
ROLLBACK;
SP_LogError('SF_DO_SOMETHING ['||depotID_i||']',SQLERRM, SQLCODE);
commit;
RETURN FAILED;
END;
END SF_DO_SOMETHING;

Oracle: 10.1.0.5.0
Java: java version "1.5.0_12"

Thanks for hints in advance!

CARSTEN

 >> Stay informed about: Problems catching Overflow 1426 jdbc 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
NLS_DATE_FORMAT in jdbc - Hi, I've seen many discussion on setting NLS_DATE_FORMAT. But when I tried to set NLS_DATE_FORMAT inside jdbc, it didn't seem to have any effect. Please see my codes below. Anyone has an idea? Many thanks CM import oracle.jdbc.pool.OracleDataSource;....

JDBC Driver 8.1.6 - Hello, Is it possible to download somewhere JDBC Driver 8.1.6 ? I would need to connect an old Oracle 7 database (The oldest one I found is 8.1.7) Thanks in advance.

Accesing XMLTYPE coumns with JDBC - I'm looking in the "Oracle Database 10g: XML & SQL" book, and I cannot find how to get the whole document that is stored in an XMLTYPE column. Right now, I'm just trying to convert to a String. Doing getString() on the ResultSet returns nul...

Number data type scale (Oracle, JDBC) - Hi, I have a table created with statement: CREATE TABLE test (field NUMBER); I inserted one value into it: INSERT INTO test VALUES (4); According to Oracle documentation: ------------------------------------------------------------ column_name..

huge returned number problems - hi all, i want to Show total purchases by supplier in 2006. and i want to nclude only those suppliers from whom we made purchases of more than 2,000,000 during the first 6 months of 2006. so i did the following: select purpmt.suppl_code as "Supplie...
   Database Help (Home) -> Oracle All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]