DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13370>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13370

[sql] DDL for INTEGER data type incorrect





------- Additional Comments From [EMAIL PROTECTED]  2002-10-07 20:30 -------
I found another similar problem, and so have written a patch for OracleBuilder which 
addresses my two issues.  There may be other SQL datatypes which need special 
handling, but filling those in should be easy.

I found this in the Oracle 8.1.7 documentation:
"Do not define columns with these SQL/DS and DB2 datatypes, because they have no 
corresponding Oracle datatype: 

*       GRAPHIC 
*       LONG VARGRAPHIC 
*       VARGRAPHIC 
*       TIME 
*       TIMESTAMP 
"

Since I had a column defined as TIMESTAMP, I needed OracleBuilder to translate that to 
DATE for me.  So while I was at it, I also added handling for INTEGER so that the 
length 
is not included.

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to