<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [Gvsig_english] new problems with an oracle layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.5945" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=787053511-29062010>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=787053511-29062010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=787053511-29062010>I have been using ogr2ogr quite a lot for importing
data into Oracle. I consider it reliable, but it has some limitations and
user should use it in a correct way. I am willing to have a try if I can get an
excerpt of the original data.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=787053511-29062010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=787053511-29062010>-Jukka Rahkonen-</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=fi dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Lähettäjä:</B>
gvsig_internacional-bounces@listserv.gva.es
[mailto:gvsig_internacional-bounces@listserv.gva.es] <B>Puolesta </B>Juan
Lucas Dominguez Rubio<BR><B>Lähetetty:</B> 29. kesäkuuta 2010
14:21<BR><B>Vastaanottaja:</B> Users and Developers mailing list;
gvsig_internacional@listserv.gva.es<BR><B>Aihe:</B> Re: [Gvsig_english] new
problems with an oracle layer<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText31116>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello,
Kornel.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I do not trust ogr2ogr,
I don't think it's a reliable tool.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>How did you create the
previous .sql file?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>You can try to use Sql
Developer as I showed in a previous screenshot to create a new .sql script.
You can download Sql Developer from:</FONT></DIV>
<DIV> </DIV>
<DIV><A
href="http://www.oracle.com/technology/software/products/sql/index.html">http://www.oracle.com/technology/software/products/sql/index.html</A></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>If you have problems to
install Sql Developer and create the .sql file, you can also try
this:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- download this file to
your PC and unzip it:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A
href="http://www.prodevelop.es/files/fm/public/downloads/sdoins.zip">http://www.prodevelop.es/files/fm/public/downloads/sdoins.zip</A></FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- you'll find a JAR
file. Double-click on it and a little dialog will appear. If it does not
appear, open a Linux terminal (or a DOS terminal in Windows) and move to the
download folder and type:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>java -jar
./sdoins.jar</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- write the correct
data in the boxes (for the max. number of rows, you can write 7000 for
example) and click "Extract". Then choose a destination file (for example
out.txt) and click OK. After a few seconds, the file will be
created.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- compress the txt file
in a ZIP file and send it to the list.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Regards,</FONT></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=idSignature26956>
<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 11:13<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>thanks for your help.<BR><BR>I´ve tested the
sql-command: <BR>SELECT SDO_UTIL.GETNUMVERTICES(c.SHAPE) FROM
PLAN.GRUEN_POLY c WHERE<BR>c.OBJECTID =
57<BR><BR>result:<BR>SDO_UTIL.GETNUMVERTICES(C.SHAPE)<BR>--------------------------------<BR>
77<BR><BR>by the manual export i had see this additional message:<BR>ogr2ogr
-f ''ESRI Shapefile'' GRUEN
OLY.shp<BR>OCI....../....@ORA12.rgu.muenchen.de -sql "select * from
plan.GRUEN_POLY"<BR>ERROR 1: ORA-04043: Object UAGRUND.DIST_TEXT_SMW is not
available in<BR>OCIDescribeAny<BR><BR><BR>Regards<BR>Kornel
Kiss<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-tp5190806p5234236.html">http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5234236.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></BLOCKQUOTE></BODY></HTML>