Hi Bruce, Thanks for the reply. Actually if use normal mapping with OQL it timestamp works fine. Other wise if use CALL SQL, oracle sends date value depending on the nls_date_format as a string. I do not know how to convert this value to timestamp. Because I have code running in production, I fixed it by having 2 separate classes( 2 separate mappings in xml file) one for query and the other for insert/update. Arun
-----Original Message----- From: Bruce Snyder [mailto:ferret@;frii.com] Sent: Tuesday, November 05, 2002 7:20 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] CALL SQL oracle date This one time, at band camp, Vennapusa, Arun said: VA>If I am calling oracle statement and it has date output. VA>How to map that value to timestamp value. VA>It throws an error saying invalid type. Arun, Castor support java.sql.Date, java.sql.Time and java.sql.Timestamp. Will those not work for you? Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
