<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.Style1, li.Style1, div.Style1
{mso-style-name:Style1;
mso-style-link:"Style1 Char";
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:72.0pt;
margin-bottom:.0001pt;
text-indent:-18.0pt;
mso-list:l0 level2 lfo1;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
text-decoration:line-through;}
span.Style1Char
{mso-style-name:"Style1 Char";
mso-style-link:Style1;
font-family:"Calibri","sans-serif";
text-decoration:line-through;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1200316672;
mso-list-type:hybrid;
mso-list-template-ids:1745920140 -727050384 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:>;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m writing a batch file to automate the loading of spatial data into our Oracle database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As a check I'm testing the Oracle connection before starting the process with a command like:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Which, if all ok, would result in:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>1: table_name_1<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>2: table_name_2<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I then in testing I added a non-existent table name:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2,NOT_A_TABLE_NAME<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Resulting (as I was expecting) in:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ERROR 1: ORA-04043: object NOT_A_TABLE_NAME does not exist<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'> in OCIDescribeAny<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ERROR 1: ORA-04043: object NOT_A_TABLE_NAME does not exist<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'> in OCIDescribeAny<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>1: table_name_1<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>2: table_name_2<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>However when checking in Oracle, the <span style='font-family:"Courier New";background:silver;mso-highlight:silver'>USER_SDO_GEOM_METADATA</span> table contained an entry for <span style='font-family:"Courier New";background:silver;mso-highlight:silver'>NOT_A_TABLE_NAME</span>. I deleted the row from the table in Oracle and tried the ogrinfo command again with "--debug on"<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='background:silver;mso-highlight:silver'><span style='mso-list:Ignore'>><span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2,NOT_A_TABLE_NAME --debug on<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal>Which had the same resultant command line output (obviously with all the debug text as well), however this time the row wasn't inserted into the <span style='font-family:"Courier New";background:silver;mso-highlight:silver'>USER_SDO_GEOM_METADATA</span> table.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Can anyone explain this behaviour, shouldn’t the<span style='font-family:"Courier New"'> <span style='background:silver;mso-highlight:silver'>-ro</span> </span>flag prevent any inserts? Also as an aside I'd be interested in knowing why the "<span style='font-family:"Courier New";background:silver;mso-highlight:silver'>ERROR 1: ORA-04043</span>" is output twice?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Initially using: GDAL 1.9.2<o:p></o:p></p><p class=MsoNormal>Updated & same on: GDAL 1.10.1<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Kind regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Rob<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>
<table><tr><td bgcolor=#ffffff><font color=#000000><pre>DISCLAIMER: The information contained in this communication/message from Robert.Langford@salford.gov.uk sent on Fri Apr 11 13:14:26 2014 is confidential. It is intended solely for the addressee(s) gdal-dev@lists.osgeo.org
Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.
As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.
Please immediately contact the sender, Robert.Langford@salford.gov.uk if you have received this message in error.
For the full disclaimer please access http://www.salford.gov.uk/e-mail. Thank you.</pre></font></td></tr></table>