# LoadAnOracleFeatureLayer

**URL:** <https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398>\
**Category:** WinForms\
**Created:** [May 1, 2009, 9:24am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398 "2009-05-01T09:24:35Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lyle](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/l/7feea3/32.png) [@Lyle](https://community.thinkgeo.com/u/Lyle)\
**Post date:** [May 1, 2009, 9:24am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/1 "2009-05-01T09:24:35Z")

</div>

Our&nbsp;data&nbsp;is&nbsp;stored&nbsp;in&nbsp;ArcSDE&nbsp;in&nbsp;Oracle&nbsp;Spatial&nbsp;format&nbsp;so&nbsp;at&nbsp;the&nbsp;moment&nbsp;am&nbsp;trying&nbsp;to&nbsp;connect&nbsp;ThinkGeo&nbsp;to&nbsp;our&nbsp;Oracle&nbsp;database.&nbsp;I&nbsp;tried&nbsp;changing&nbsp;the&nbsp;example&nbsp;"LoadAnOracleFeatureLayer.cs"&nbsp;that&nbsp;came&nbsp;with&nbsp;the&nbsp;setup.&nbsp;So&nbsp;far&nbsp;without&nbsp;any&nbsp;luck.&nbsp;It&nbsp;says&nbsp;it&nbsp;can't&nbsp;resolve&nbsp;the&nbsp;TNS&nbsp;I&nbsp;supplied&nbsp;{"ORA-12154:&nbsp;TNS:could&nbsp;not&nbsp;resolve&nbsp;the&nbsp;connect&nbsp;identifier&nbsp;specified\n"}.&nbsp;The&nbsp;TNS&nbsp;I&nbsp;use&nbsp;is&nbsp;valid&nbsp;and&nbsp;works&nbsp;with&nbsp;other&nbsp;applications.  
  
  
  
Maybe&nbsp;you&nbsp;can&nbsp;help?

---

<div class="post-metadata">

**Author:** ![Lee](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/l/bc8723/32.png) [@Lee](https://community.thinkgeo.com/u/Lee)\
**Post date:** [May 5, 2009, 6:47am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/2 "2009-05-05T06:47:06Z")

</div>

Lyle,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Could&nbsp;you&nbsp;tell&nbsp;more&nbsp;about&nbsp;how&nbsp;you&nbsp;connect&nbsp;to&nbsp;the&nbsp;Oracle&nbsp;Server&nbsp;as&nbsp;we&nbsp;can&nbsp;not&nbsp;recreate&nbsp;this&nbsp;issue.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Thanks,&nbsp;  
&nbsp;ThinkGeo&nbsp;Support&nbsp;

---

<div class="post-metadata">

**Author:** ![ernstjan\_henkens](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/e/8c91f0/32.png) [@ernstjan\_henkens](https://community.thinkgeo.com/u/ernstjan_henkens)\
**Post date:** [May 5, 2009, 10:17am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/3 "2009-05-05T10:17:24Z")

</div>

private&nbsp;void&nbsp;LoadOracleLayer()&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Controls.Clear();&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Controls.Add(winformsMap1);&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;winformsMap1.MapUnit&nbsp;=&nbsp;GeographyUnit.Meter;&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;winformsMap1.CurrentExtent&nbsp;=&nbsp;new&nbsp;RectangleShape(0,&nbsp;750000,300000,300000);&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;winformsMap1.MapBackground.BackgroundBrush&nbsp;=&nbsp;new&nbsp;GeoSolidBrush(GeoColor.GeographicColors.ShallowOcean);&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;string&nbsp;connectString&nbsp;=&nbsp;"User&nbsp;ID=uid;Password=pwd;Data&nbsp;Source=tegsist.world;";&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OracleFeatureLayer&nbsp;oracleLayer&nbsp;=&nbsp;new&nbsp;OracleFeatureLayer(connectString,&nbsp;"topo25",&nbsp;"objectid");&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[//oracleLayer.ZoomLevelSet.ZoomLevel01.DefaultAreaStyle](https://oracleLayer.ZoomLevelSet.ZoomLevel01.DefaultAreaStyle)&nbsp;=&nbsp;AreaStyles.Country1;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[//oracleLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel](https://oracleLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel)&nbsp;=&nbsp;ApplyUntilZoomLevel.Level20;&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;winformsMap1.StaticOverlay.Layers.Add("OracleLayer",&nbsp;oracleLayer);&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;winformsMap1.Refresh();&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;  
&nbsp;&nbsp;  
&nbsp;In&nbsp;this&nbsp;case&nbsp;Tegsist.world&nbsp;is&nbsp;the&nbsp;name&nbsp;of&nbsp;the&nbsp;entry&nbsp;in&nbsp;the&nbsp;tnsnames.ora&nbsp;file

---

<div class="post-metadata">

**Author:** ![Lee](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/l/bc8723/32.png) [@Lee](https://community.thinkgeo.com/u/Lee)\
**Post date:** [May 8, 2009, 3:00am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/4 "2009-05-08T03:00:45Z")

</div>

Thanks&nbsp;Ernst-jan,&nbsp;  
&nbsp;&nbsp;  
&nbsp;We&nbsp;will&nbsp;look&nbsp;into&nbsp;it&nbsp;and&nbsp;let&nbsp;you&nbsp;know&nbsp;the&nbsp;result.&nbsp;  
&nbsp;&nbsp;  
&nbsp;ThinkGeo&nbsp;Support

---

<div class="post-metadata">

**Author:** ![David](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@David](https://community.thinkgeo.com/u/David)\
**Post date:** [May 9, 2009, 8:57pm UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/5 "2009-05-09T20:57:57Z")

</div>

Lyle,&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;I&nbsp;think&nbsp;I&nbsp;may&nbsp;know&nbsp;what&nbsp;the&nbsp;problem&nbsp;is.&nbsp;&nbsp;Since&nbsp;you&nbsp;are&nbsp;using&nbsp;ArcSDE&nbsp;the&nbsp;format&nbsp;of&nbsp;the&nbsp;data&nbsp;in&nbsp;Oracle&nbsp;is&nbsp;the&nbsp;custom&nbsp;ArcSDE&nbsp;format&nbsp;which&nbsp;is&nbsp;very&nbsp;different&nbsp;from&nbsp;the&nbsp;native&nbsp;Spatial&nbsp;format&nbsp;Oracle&nbsp;uses.&nbsp;&nbsp;Our&nbsp;OracleFeatureLayer&nbsp;is&nbsp;designed&nbsp;to&nbsp;access&nbsp;data&nbsp;in&nbsp;a&nbsp;standalone&nbsp;Oracle&nbsp;Spatial&nbsp;table&nbsp;using&nbsp;the&nbsp;Oracle&nbsp;Spatial&nbsp;API.&nbsp;&nbsp;It&nbsp;is&nbsp;my&nbsp;understanding&nbsp;that&nbsp;ArcSDE&nbsp;has&nbsp;its&nbsp;own&nbsp;table&nbsp;format&nbsp;it&nbsp;uses&nbsp;in&nbsp;Oracle&nbsp;as&nbsp;it&nbsp;supported&nbsp;spatial&nbsp;features&nbsp;way&nbsp;before&nbsp;Oracle&nbsp;introduced&nbsp;Oracle&nbsp;Spatial.&nbsp;&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;The&nbsp;solution&nbsp;to&nbsp;this&nbsp;is&nbsp;to&nbsp;use&nbsp;our&nbsp;ArcSDE&nbsp;connector&nbsp;which&nbsp;is&nbsp;currently&nbsp;in&nbsp;limited&nbsp;Alpha&nbsp;right&nbsp;now.&nbsp;&nbsp;We&nbsp;are&nbsp;working&nbsp;through&nbsp;some&nbsp;issue&nbsp;with&nbsp;it.&nbsp;&nbsp;Currently&nbsp;we&nbsp;do&nbsp;not&nbsp;have&nbsp;a&nbsp;release&nbsp;data&nbsp;but&nbsp;that&nbsp;is&nbsp;what&nbsp;you&nbsp;will&nbsp;need&nbsp;to&nbsp;access&nbsp;your&nbsp;ArcSDE&nbsp;data&nbsp;regardless&nbsp;of&nbsp;the&nbsp;back-end&nbsp;format.&nbsp;  
&nbsp;&nbsp;  
&nbsp;David

---

<div class="post-metadata">

**Author:** ![ernstjan\_henkens](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/e/8c91f0/32.png) [@ernstjan\_henkens](https://community.thinkgeo.com/u/ernstjan_henkens)\
**Post date:** [May 11, 2009, 6:47am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/6 "2009-05-11T06:47:34Z")

</div>

David,&nbsp;  
&nbsp;&nbsp;  
&nbsp;As&nbsp;mentioned&nbsp;earlier&nbsp;the&nbsp;data&nbsp;is&nbsp;stored&nbsp;in&nbsp;Oracle&nbsp;Spatial&nbsp;format&nbsp;(&nbsp;SDO\_GEOMETRY)&nbsp;this&nbsp;is&nbsp;an&nbsp;option&nbsp;in&nbsp;ArcSDE&nbsp;  
&nbsp;&nbsp;  
&nbsp;The&nbsp;error&nbsp;message&nbsp;suggests&nbsp;a&nbsp;problem&nbsp;with&nbsp;the&nbsp;Oracle&nbsp;connection.&nbsp;  
&nbsp;&nbsp;  
&nbsp;{"ORA-12154:&nbsp;TNS:could&nbsp;not&nbsp;resolve&nbsp;the&nbsp;connect&nbsp;identifier&nbsp;specified\n"}.&nbsp;  
&nbsp;&nbsp;  
&nbsp;EJ

---

<div class="post-metadata">

**Author:** ![Ben](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ben/32/25720_2.png) [@Ben](https://community.thinkgeo.com/u/Ben)\
**Post date:** [May 20, 2009, 9:47am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/7 "2009-05-20T09:47:41Z")

</div>

Ernst-jan,&nbsp;

Sorry&nbsp;for&nbsp;the&nbsp;delay&nbsp;on&nbsp;our&nbsp;end.  
&nbsp;  
We&nbsp;spent&nbsp;some&nbsp;time&nbsp;trying&nbsp;to&nbsp;recreate&nbsp;this&nbsp;issue&nbsp;but&nbsp;failed.&nbsp;Anyway,&nbsp;please&nbsp;check&nbsp;the&nbsp;following&nbsp;items.  
&nbsp;  
1,&nbsp;Please&nbsp;download&nbsp;the&nbsp;TempOracleExtension&nbsp;in&nbsp;which&nbsp;we&nbsp;have&nbsp;some&nbsp;bug&nbsp;fixed&nbsp;on&nbsp;the&nbsp;Oracle&nbsp;Layer.&nbsp;This&nbsp;assembly&nbsp;will&nbsp;be&nbsp;integrated&nbsp;in&nbsp;the&nbsp;upcoming&nbsp;public&nbsp;release.  
[gis.thinkgeo.com/Support/DiscussionForums/tabid/143/aff/12/aft/5576/afv/topic/Default.aspx](http://gis.thinkgeo.com/Support/DiscussionForums/tabid/143/aff/12/aft/5576/afv/topic/Default.aspx)  
&nbsp;  
2,&nbsp;in&nbsp;a&nbsp;connection&nbsp;string,&nbsp;I&nbsp;think&nbsp;we&nbsp;need&nbsp;both&nbsp;server&nbsp;name&nbsp;and&nbsp;service&nbsp;name&nbsp;for&nbsp;a&nbsp;data&nbsp;source,&nbsp;such&nbsp;as&nbsp;“Data&nbsp;Source=192.168.0.178/orcl”&nbsp;(“orcl”&nbsp;is&nbsp;the&nbsp;service&nbsp;name).&nbsp;I&nbsp;didn't&nbsp;see&nbsp;the&nbsp;server&nbsp;name&nbsp;in&nbsp;your&nbsp;connection&nbsp;string&nbsp;though,&nbsp;maybe&nbsp;that's&nbsp;a&nbsp;reason.  
&nbsp;  
3&nbsp;Just&nbsp;wonder&nbsp;are&nbsp;you&nbsp;using&nbsp;the&nbsp;Oracle&nbsp;Express&nbsp;Edition&nbsp;as&nbsp;we&nbsp;don’t&nbsp;fully&nbsp;support&nbsp;that.&nbsp;If&nbsp;not,&nbsp;could&nbsp;you&nbsp;make&nbsp;sure&nbsp;you&nbsp;are&nbsp;using&nbsp;the&nbsp;correct&nbsp;table&nbsp;name&nbsp;and&nbsp;geometry&nbsp;column&nbsp;name&nbsp;in&nbsp;codes&nbsp;(with&nbsp;the&nbsp;correct&nbsp;cases).&nbsp;And&nbsp;what’s&nbsp;your&nbsp;oracle&nbsp;version,&nbsp;the&nbsp;one&nbsp;we&nbsp;are&nbsp;testing&nbsp;is&nbsp;11.1g  
  
&nbsp;  
As&nbsp;this&nbsp;exception&nbsp;seems&nbsp;quite&nbsp;common&nbsp;in&nbsp;google&nbsp;and&nbsp;most&nbsp;of&nbsp;them&nbsp;are&nbsp;setting&nbsp;related&nbsp;issues,&nbsp;could&nbsp;you&nbsp;double&nbsp;check&nbsp;your&nbsp;Oracle&nbsp;settings?&nbsp;Maybe&nbsp;that&nbsp;will&nbsp;work.  
  
&nbsp;  
If&nbsp;you&nbsp;still&nbsp;have&nbsp;this&nbsp;problem,&nbsp;can&nbsp;you&nbsp;let&nbsp;me&nbsp;know&nbsp;more&nbsp;how&nbsp;to&nbsp;recreate&nbsp;this&nbsp;issue?&nbsp;It&nbsp;will&nbsp;be&nbsp;great&nbsp;if&nbsp;you&nbsp;can&nbsp;let&nbsp;us&nbsp;know&nbsp;how&nbsp;to&nbsp;build&nbsp;the&nbsp;same&nbsp;data&nbsp;base&nbsp;as&nbsp;yours.  
&nbsp;  
Thanks,  
&nbsp;  
Ben

---

<div class="post-metadata">

**Author:** ![gkostakis](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/g/ecb155/32.png) [@gkostakis](https://community.thinkgeo.com/u/gkostakis)\
**Post date:** [August 27, 2009, 3:36am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/8 "2009-08-27T03:36:34Z")

</div>

Hi,&nbsp;  
&nbsp;I&nbsp;had&nbsp;the&nbsp;same&nbsp;issue&nbsp;when&nbsp;I&nbsp;tried&nbsp;the&nbsp;sample&nbsp;the&nbsp;first&nbsp;time.&nbsp;To&nbsp;sort&nbsp;it&nbsp;out,&nbsp;I&nbsp;simply&nbsp;created&nbsp;and&nbsp;opened&nbsp;my&nbsp;own&nbsp;oracle&nbsp;connection.&nbsp;After&nbsp;that&nbsp;it&nbsp;works.&nbsp;It&nbsp;seems&nbsp;that&nbsp;the&nbsp;problem&nbsp;is&nbsp;that&nbsp;it&nbsp;expects&nbsp;a&nbsp;connection&nbsp;to&nbsp;be&nbsp;available&nbsp;&nbsp;in&nbsp;the&nbsp;pool.&nbsp;  
&nbsp;After&nbsp;that&nbsp;i’m&nbsp;getting:&nbsp;ORA-00936:&nbsp;missing&nbsp;expression&nbsp;when&nbsp;trying&nbsp;to&nbsp;display&nbsp;the&nbsp;layer…&nbsp;  
&nbsp;&nbsp;  
&nbsp;&nbsp;  
&nbsp;cheers,&nbsp;  
&nbsp;George

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [August 27, 2009, 3:44am UTC](https://community.thinkgeo.com/t/loadanoraclefeaturelayer/398/9 "2009-08-27T03:44:04Z")

</div>

George,

Thanks&nbsp;for&nbsp;your&nbsp;post&nbsp;and&nbsp;welcome&nbsp;you&nbsp;to&nbsp;ThinkGeo&nbsp;Map&nbsp;Suite&nbsp;Desktop&nbsp;Forum!

Following&nbsp;post&nbsp;also&nbsp;talks&nbsp;about&nbsp;the&nbsp;same&nbsp;issue,&nbsp;please&nbsp;take&nbsp;a&nbsp;look&nbsp;if&nbsp;you&nbsp;are&nbsp;interested:  
  
[gis.thinkgeo.com/Support/Dis...fault.aspx](http://gis.thinkgeo.com/Support/DiscussionForums/tabid/143/aff/12/aft/5392/afv/topic/afpg/1/Default.aspx)

Let&nbsp;me&nbsp;know&nbsp;if&nbsp;any&nbsp;more&nbsp;questions!

Thanks.

Yale  
  
&nbsp;