<HTML><HEAD><TITLE>Re: [Gvsig_english] new problems with an oracle layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17063" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText23138>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello. Here is the new informal patch (instructions inside) in case you want to test it:</FONT></DIV>
<DIV> </DIV>
<DIV><A href="http://www.prodevelop.es/files/fm/public/downloads/oracle_spatial_patch_gvsig_1.9_30_june_2010.zip">http://www.prodevelop.es/files/fm/public/downloads/oracle_spatial_patch_gvsig_1.9_30_june_2010.zip</A></DIV>
<DIV> </DIV>
<DIV>Let me know if you have the same issue.</DIV>
<DIV>Anyway, gvSIG 1.10 is very close I think.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature33318>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Juan Lucas Dominguez Rubio<BR><B>Enviado el:</B> mié 30/06/2010 10:52<BR><B>Para:</B> Users and Developers mailing list; gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] new problems with an oracle layer<BR></FONT><BR></DIV>
<DIV>
<DIV id=idOWAReplyText59528>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, thanks. Yes I also had those problems after using Sql Developer. The "too many arguments" problem probably occurs because the SQL interpreter does not accept such a long array in text mode, but I don't think that's a bad geometry.</FONT></DIV>
<DIV> </DIV>
<DIV>With those 6192 geometries I have been able to reproduce the error. It is again an 'out of memory' error caused by a large resultset buffer (sorry, I did not fix it well a few days ago).</DIV>
<DIV> </DIV>
<DIV>I have already fixed this. I'm going to send you a new patch.</DIV>
<DIV>This will be included in the upcoming gvSIG 1.10 </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature19537>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de K.Kiss<BR><B>Enviado el:</B> mar 29/06/2010 16:58<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] new problems with an oracle layer<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>hello,<BR><BR>i installed the "sqldeveloper" -32Bit -Version. It works.<BR>But in the "sqldeveloper"-export-file are several errors existing:<BR><BR><A href="http://osgeo-org.1803224.n2.nabble.com/file/n5235335/GRUEN_POLY_export.zip">http://osgeo-org.1803224.n2.nabble.com/file/n5235335/GRUEN_POLY_export.zip</A><BR>GRUEN_POLY_export.zip<BR><BR>1.The entry ''null'', is not ok; please replace it into --> NULL, <BR>and the script will work.<BR><BR>By the inserting of the script it comes to several errors: "ORA-00939: To<BR>many arguments for the function."<BR><BR>6192 rows (total 6242) are inserted in my own copy.<BR><BR><BR><BR><BR>-----<BR>Kornel Kiss<BR><BR>Referat für Gesundheit und Umwelt<BR>Anforderungsmanagement Fachanwendungen<BR>Bayerstr. 28a<BR>80335 München<BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5235335.html">http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5235335.html</A><BR>Sent from the gvSIG international mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></DIV></BODY></HTML>