db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hammonds, Nicholas" <Nicholas.Hammo...@thus.net>
Subject Problem with stored procedure names
Date Thu, 01 May 2008 10:18:53 GMT
Hello all,

I have a third party stored procedure I need to call,

I'm using apache derby as a in memory database for the purposes of unit

In order to call the procedure on apache derby you must put double
quotes around the procedure name as follows

addMessage = (CallableStatement)connection.prepareCall(

Without the double quotes apache derby complains about a syntax error at
the second the '.'.

Now Oracle 9i wants things the other way round

If I call the procedure on oracle9i as follows
addMessage = (CallableStatement)connection.prepareCall(

It barfs with ' caught SQLException: ORA-06550: line 1, column 7:
PLS-00114: identifier 'custom.ipa_post_message.ipa_po' too long'

The way to get around that oracle exception is to remove the double
quotes around the stored procedure name, in otherwords:

addMessage = (CallableStatement)connection.prepareCall(

This is obviously not ideal for unit testing as I want my code that
speaks to the DB to be the same whether it is speaking to apache derby
oracle 9i.

Anyone know of a way so I can call that stored procedure in the same way
on apache derby and oracle.

Many Thanks

View raw message