Hi all,
This is issue
http://www.openoffice.org/issues/show_bug.cgi?id=50407
Bye Marc
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Peter,
the following error occurs, if I save a table created with the designer:
ORA-00906: left parenthesis missing
I get the same hint, if I drag a HSQL table structure into an oracle
jdbc db.
I suppose this is something about the driver returning wrong meta data.
OOo asks the driver whether the column types in the CREATE TABLE
statement need/allow parameters (e.g. "CREATE TABLE ... VARCHAR( 10 )
...") or not [1], and the error message you cite sounds like Base
decided to not use parameters for one of the types, but Oracle expects them.
I don't think there's an issue for this already, so please submit one so
we will at time investigate whether this is an Oracle/JDBC or Base issue.
Thanks & Ciao
Frank
[1] see the CREATE_PARAMS in
http://java.sun.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo()
--
Sun Microsystems GmbH Marc Neumann
Nagelsweg 55 Quality Assurance Engineer
D-20097 Hamburg OpenOffice.org Base
http://www.sun.de mailto:[EMAIL PROTECTED]
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Marcel Schneider, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
