1
vote
0answers
23 views

Using IRelationalOperator ArcObjects interface with feature classes stored in Oracle?

Could you give an example how you’d use the IRelationalOperator ArcObjects interface with features from different feature classes stored in oracle database? In my visual studio project I have an xml ...
2
votes
1answer
78 views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...
0
votes
0answers
35 views

NextBuffer operation takes a long time when there are no rows in a table

We're trying to get data from a table which contains no rows. The query runs fast, but the SDE gets stuck on NextBuffer command. Some code that we're using: IQueryName2 queryName2 = (IQueryName2)new ...
0
votes
3answers
257 views

For a SDE FeatureClasses list all Roles that have been Granted any Privileges on it, and which Privileges each Role have on it

I have searched through the ArcObjects 10 SDK API and googled, but havnt been able to find what I am looking for, so thats the reason for me posting this question. Q: How can I for a SDE ...
1
vote
1answer
174 views

SDE FeatureClass Granting and Revoking Privilege with ArcObjects

Q: How can I with ArcObjects GRANT or REVOKE Privileges like SELECT, UPDATE on SDE FeatureClasses to/from Roles? The equivalent in normal Oracle would be something like this: GRANT SELECT ON ...
4
votes
2answers
659 views

How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?

I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
5
votes
1answer
182 views

ArcObjects edit/update ODBC Oracle table

Can an ODBC Oracle table attached by OLE within ArcMap be edited/updated by using ArcObjects? If so, what are the procedural steps for doing this? Are there code examples out there showing how to do ...
4
votes
2answers
393 views

ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue

New to stack exchange, heading over from the esri forums, it is great! I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
14
votes
3answers
2k views

ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)

UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156). I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...