<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>
<div>Francisco,</div>
<div><br>
</div>
<div>Change your DATA statement to be : <span style="font-size: 15px;">DATA "MI_SHAPE FROM CONSEJOSPOPULARES using SRID 4326"</span></div>
<div><span style="font-size: 15px;"><br>
</span></div>
<div><span style="font-size: 15px;">Eg, remove the = sign.</span></div>
<div><span style="font-size: 15px;"><br>
</span></div>
<div><span style="font-size: 15px;">Mike</span></div>
<div>
<div>
<div>----</div>
<div>Michael Smith</div>
</div>
<div>US Army Corps</div>
<div>Remote Sensing GIS/Center</div>
<div>michael.smith@usace.army.mil</div>
<div><br>
</div>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Francisco Salas Rosette <<a href="mailto:fsalas@pinar.geocuba.cu">fsalas@pinar.geocuba.cu</a>><br>
<span style="font-weight:bold">Date: </span>Monday, June 1, 2015 at 8:08 AM<br>
<span style="font-weight:bold">To: </span>mapserver-users <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>[EXTERNAL] [mapserver-users] Failed to draw Oracle9i layer<br>
<span style="font-weight:bold">Resent-From: </span>Michael Smith <<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>><br>
</div>
<div><br>
</div>
<blockquote id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE" style="BORDER-LEFT: #b5c4df 5 solid; PADDING:0 0 0 5; MARGIN:0 0 0 5;">
<div 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">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@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";
mso-fareast-language:EN-US;}
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.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Texto sin formato Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.TextosinformatoCar
{mso-style-name:"Texto sin formato Car";
mso-style-priority:99;
mso-style-link:"Texto sin formato";
font-family:"Calibri","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></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]-->
<div lang="ES" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">I am having trouble making one test with loading the Oracle9i layer , using PHP Version 5.4.3 and MapServer CGI 6.0.3
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The layer definition in my map file is :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">LAYER<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME Consejo_Popular<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> TYPE POLYGON<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">STATUS ON<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONNECTIONTYPE oraclespatial<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONNECTION "******/*****@catastro"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> DATA "MI_SHAPE FROM CONSEJOSPOPULARES using SRID=4326"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> DUMP TRUE<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> CLASS <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> OUTLINECOLOR 0 0 0<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 0 128 128<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> END <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> END <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I use this “<b><i>Steps to Enable Oracle 10g or 11g Support in MS4W</i></b>” , but I test in oracle9i
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And launch this error message , <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Warning: mapObj::draw(): [MapServer Error]: msDrawMap(): Failed to draw layer named 'Consejo_Popular'. in C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on line 108<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Warning: mapObj::draw(): [MapServer Error]: msOracleSpatialLayerWhichShapes(): Error: ORA-29902: error in executing ODCIIndexStart() routine ORA-01722: invalid number . Query statement: SELECT rownum, MI_SHAPE FROM CONSEJOSPOPULARES
WHERE SDO_FILTER( MI_SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' . Check your data statement. in C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on line 108<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">How resolve this problems ??<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks , <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Francisco Salas <o:p></o:p></span></p>
</div>
<br>
<pre>----------------------------------------------------------------------------------------------------
Anuncie sus servicios en ANDARIEGO? aplicaci?n para celulares sobre mapas de toda Cuba.
Visite el sitio <a href="http://andariego.geocuba.cu">http://andariego.geocuba.cu</a> o <a href="http://www.andariego.cu">http://www.andariego.cu</a>, cont?ctenos por el correo <a href="mailto:andariego@geosi.geocuba.cu">andariego@geosi.geocuba.cu</a> o por el tel?fono 8817400.
Ponga su informaci?n al servicio de todos.
</pre>
<br>
</div>
</div>
</blockquote>
</span>
</body>
</html>