<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:Verdana;
        color:blue;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Hi All,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I want to retrieve the Geometry stored
in oracle spatial.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I have written the below code <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>private</span></font> <font color=teal><span
style='color:teal'>IProviderRegistry</span></font> <font color=black><span
style='color:black'>FDORegistry</span></font> = <font color=teal><span
style='color:teal'>FeatureAccessManager</span></font>.<font color=black><span
style='color:black'>GetProviderRegistry</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>private</span></font> <font color=teal><span
style='color:teal'>IConnectionManager</span></font> <font color=black><span
style='color:black'>FDOManager</span></font> = <font color=teal><span
style='color:teal'>FeatureAccessManager</span></font>.<font color=black><span
style='color:black'>GetConnectionManager</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>private</span></font> <font color=teal><span
style='color:teal'>IConnection</span></font> <font color=black><span
style='color:black'>FDOConnection</span></font> = <font color=teal><span
style='color:teal'>FeatureAccessManager</span></font>.<font color=black><span
style='color:black'>GetConnectionManager</span></font>().<font color=black><span
style='color:black'>CreateConnection</span></font>(<font color=maroon><span
style='color:maroon'>"OSGeo.KingOracle.3.3"</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>public</span></font> <font color=teal><span
style='color:teal'>ConnectionState</span></font> <font color=black><span
style='color:black'>Constate</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>string</span></font> <font color=black><span
style='color:black'>featureclsname</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>public</span></font> <font color=black><span
style='color:black'>FDOKingOracleClass</span></font>(<font color=blue><span
style='color:blue'>string</span></font> <font color=black><span
style='color:black'>username</span></font>,<font color=blue><span
style='color:blue'>string</span></font> <font color=black><span
style='color:black'>password</span></font>,<font color=blue><span
style='color:blue'>string</span></font> <font color=black><span
style='color:black'>servicename</span></font>,<font color=blue><span
style='color:blue'>string</span></font> <font color=black><span
style='color:black'>featureclassname</span></font>)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>ConnectionInfo</span></font>.<font
color=black><span style='color:black'>ConnectionProperties</span></font>.<font
color=black><span style='color:black'>SetProperty</span></font>(<font
color=maroon><span style='color:maroon'>"Username"</span></font>, <font
color=black><span style='color:black'>username</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>ConnectionInfo</span></font>.<font
color=black><span style='color:black'>ConnectionProperties</span></font>.<font
color=black><span style='color:black'>SetProperty</span></font>(<font
color=maroon><span style='color:maroon'>"Password"</span></font>, <font
color=black><span style='color:black'>password</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>ConnectionInfo</span></font>.<font
color=black><span style='color:black'>ConnectionProperties</span></font>.<font
color=black><span style='color:black'>SetProperty</span></font>(<font
color=maroon><span style='color:maroon'>"Service"</span></font>, <font
color=black><span style='color:black'>servicename</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>ConnectionInfo</span></font>.<font
color=black><span style='color:black'>ConnectionProperties</span></font>.<font
color=black><span style='color:black'>SetProperty</span></font>(<font
color=maroon><span style='color:maroon'>"OracleSchema"</span></font>,
<font color=black><span style='color:black'>servicename</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>ConnectionInfo</span></font>.<font
color=black><span style='color:black'>ConnectionProperties</span></font>.<font
color=black><span style='color:black'>SetProperty</span></font>(<font
color=maroon><span style='color:maroon'>"KingFdoClass"</span></font>,
<font color=black><span style='color:black'>featureclassname</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>featureclsname</span></font> = <font
color=black><span style='color:black'>featureclassname</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>Constate</span></font> = <font
color=black><span style='color:black'>FDOConnection</span></font>.<font
color=black><span style='color:black'>Open</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I am able to open the connection without
any error… but I could not able to retrieve the geometry collection.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I am getting the error in below code….<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'> public</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=teal><span
style='color:teal'>GeometryCollection</span></font> <font color=black><span
style='color:black'>SelectAllQuery</span></font>()<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>GeometryCollection</span></font> <font
color=black><span style='color:black'>Geo_Collection</span></font> = <font
color=blue><span style='color:blue'>new</span></font> <font color=teal><span
style='color:teal'>GeometryCollection</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>try<o:p></o:p></span></font></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>ISelect</span></font> <font color=black><span
style='color:black'>sel</span></font> = (<font color=teal><span
style='color:teal'>ISelect</span></font>)<font color=black><span
style='color:black'>FDOConnection</span></font>.<font color=black><span
style='color:black'>CreateCommand</span></font>(<font color=black><span
style='color:black'>OSGeo</span></font>.<font color=black><span
style='color:black'>FDO</span></font>.<font color=black><span style='color:
black'>Commands</span></font>.<font color=teal><span style='color:teal'>CommandType</span></font>.<font
color=black><span style='color:black'>CommandType_Select</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>sel</span></font>.<font color=black><span
style='color:black'>SetFeatureClassName</span></font>(<font color=black><span
style='color:black'>featureclsname</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=green><span style='color:green'>// sel.LockType =
OSGeo.FDO.Commands.Locking.LockType.LockType_Unsupported;<o:p></o:p></span></font></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=green
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:green'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=green
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:green'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>IFeatureReader</span></font> <font
color=black><span style='color:black'>FDOReader</span></font> = <font
color=black><span style='color:black'>sel</span></font>.<font color=black><span
style='color:black'>Execute</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>FgfGeometryFactory</span></font> <font
color=black><span style='color:black'>gFac</span></font> = <font color=blue><span
style='color:blue'>new</span></font> <font color=teal><span style='color:teal'>FgfGeometryFactory</span></font>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>while</span></font> (<font color=black><span
style='color:black'>FDOReader</span></font>.<font color=black><span
style='color:black'>ReadNext</span></font>())<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>Byte</span></font>[] <font color=black><span
style='color:black'>Tmppts</span></font> = <font color=black><span
style='color:black'>FDOReader</span></font>.<font color=black><span
style='color:black'>GetGeometry</span></font>(<font color=maroon><span
style='color:maroon'>"Geometry"</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=black><span style='color:black'>Geo_Collection</span></font>.<font
color=black><span style='color:black'>Add</span></font>(<font color=black><span
style='color:black'>gFac</span></font>.<font color=black><span
style='color:black'>CreateGeometryFromFgf</span></font>(<font color=black><span
style='color:black'>Tmppts</span></font>));<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>catch</span></font>(<font color=black><span
style='color:black'>OSGeo</span></font>.<font color=black><span
style='color:black'>FDO</span></font>.<font color=black><span style='color:
black'>Common</span></font>.<font color=teal><span style='color:teal'>Exception</span></font>
<font color=black><span style='color:black'>ex</span></font>)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=teal><span style='color:teal'>MessageBox</span></font>.<font color=black><span
style='color:black'>Show</span></font>(<font color=black><span
style='color:black'>ex</span></font>.<font color=black><span style='color:black'>Message</span></font>.<font
color=black><span style='color:black'>ToString</span></font>());<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>return</span></font> <font color=black><span
style='color:black'>Geo_Collection</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>If anybody has the code to retrieve the
spatial data, please help me.<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> Thank You,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=olive face=Verdana><span
style='font-size:9.0pt;font-family:Verdana;color:olive'>Regards</span></font><font
size=1 color=blue face=Verdana><span style='font-size:9.0pt;font-family:Verdana;
color:blue'>,</span></font><font color=blue><span style='color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><strong><b><font size=1 color=blue face=Verdana><span
style='font-size:9.0pt;font-family:Verdana;color:blue'>Shaik Esu,</span></font></b></strong><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=navy face=Verdana><span style='font-size:
9.0pt;font-family:Verdana;color:navy'>Sr Software Engineer,</span></font><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=navy face=Verdana><span style='font-size:
9.0pt;font-family:Verdana;color:navy'>Infotech Enterprises Ltd,</span></font><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=navy face=Verdana><span style='font-size:
9.0pt;font-family:Verdana;color:navy'>Extn: 740.</span></font><font color=blue><span
style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=navy face=Verdana><span style='font-size:
9.0pt;font-family:Verdana;color:navy'>Mobile +91 9849538712.</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>