Latest Contributions by RobertParsons

‎09-27-2016

Derek thank you for your insight. I will make that idea request. Rob

‎09-27-2016

Hello, Is there a way to format the surveys for an iPad? Or is there a way to format groups side by side instead of scrolling from top to bottom. Or, another way to ask, Is there a way to maximize the use of the screen real estate of an ipad for surveys. Thanks, Rob Parsons

‎08-07-2014

Robyn, My apologies, I had not been monitoring this and have since changed jobs. However, I can answer that question, in that on the remote database the sql that you write to select from the Geo-aware database should not include the shape field. The ArcSDE multi-versioned view is just a view not a materialized view. For example: select attr1, attr2 from geoAwareDatabase@remote_oracle would be good. Not Good: select attr1, attr2, shape from geoAwareDatabae@remote_oracle; Going through the DBLink would not work. Now with updates and upgrades that may have changed. Happy Oracleing, Rob P.

‎04-25-2012

For those that are interested. It has been resolved. In fact the error that is in the Title of this thread was not the real cause it was a ORA-22804. Remote operations not permitted on object tables with a user-defined type. We moved to the ST_GEOMETRY datatype from SDEBinary. As this was a dblink to the GIS ArcSDE Database from the Asset management system it did not work. We altered the PLSQL and it is now working. In the future if you are selecting from a multi-versioned view do not include the shape field if you are using ST_GEOMETRY. Thanks to ESRI Tech Support for nailing this one down. Happy Oracleing, Rob

‎04-20-2012

Anthony, The multi-versioned views are brand new, created after I moved the data from ArcSDE 9.3.1 to ArcSDE 10. Do I need to just select the mv views from the asset manangement system through sql so that the asset management resets to st_geometry. I would have thought that a recompile would accomplish that. Thanks, Rob

‎04-20-2012

Anthony, Thanks for reply. I have seen the Oracle Metalink article that you are referring too. So, does that mean that an ArcSDE Multi-Versioned View is another term for Oracle Materialized View? If so, then when we upgraded from 9.3.1 to 10 I moved the data into a brand new system (Oracle11G) Versioned the features then created the Multi-Versioned Views. The PLSQL that is selecting data from the Multi-Versioned view is still in Oracle 10G. From that 10G database I can login using SQLPlus and perform the queries with no problem against the multi-versioned view but the plsql package cannot. I will look into how Oracle "sees" the multi-versioned view, maybe that will give me some clues, but any other additional troubleshooting tips would be greatly appreciated. Rob P.

‎04-19-2012

Fellow ArcSDE Professionals: We currently have an Oracle10G asset management system that select new records on our ArcSDE database through a multi-versioned view that then creates new assests in the Asset Management System. We have just upgraded to ArcSDE 10 on Oracle 11G and when we attempt to compile the PL/SQL on the Oracle10G instance the following errors occur: Error(218,4): PL/SQL: SQL Statement ignored Error(219,20): PL/SQL: ORA-21700: object does not exist or is marked for delete Error(230,4): PL/SQL: SQL Statement ignored Error(231,20): PL/SQL: ORA-21700: object does not exist or is marked for delete Error(242,4): PL/SQL: SQL Statement ignored Error(243,20): PL/SQL: ORA-21700: object does not exist or is marked for delete The old database we were using SDEBinary, on the new database we are using ST_GEOMETRY. Thanks in advance for any insight and or troubleshooting tips. Rob Parsons City of Columbus, Ohio

‎04-07-2010

Thanks Kirk I will look into that. I am having an issue creating a replica and one of the issues that was returned is "a feature class may be registered as versioned with the option of moving edits to base". This prevents me from creating the replica. So, I was curious if I could query the metadata tables in Oracle directly. However If I can use your suggestion I will. Thanks, Rob P.

‎04-07-2010

Is there a way to tell in the GDB Metadata tables if a feature class is registered with the option to move edits to base? From ArcCatalog I only see "This feature class is registered as versioned". Is there a check mark? Thanks for any insight. Rob P.

Online Status	Offline
Date Last Visited	‎12-14-2023 12:20 PM

My Ideas

Latest Contributions by RobertParsons

Re: Format for iPad

Format for iPad

Re: PL/SQL: ORA-21700 object does not exist. . . Oracle10g to SDE 10/Oracle11G

Re: PL/SQL: ORA-21700 object does not exist. . . Oracle10g to SDE 10/Oracle11G

Re: PL/SQL: ORA-21700 object does not exist. . . Oracle10g to SDE 10/Oracle11G

Re: PL/SQL: ORA-21700 object does not exist. . . Oracle10g to SDE 10/Oracle11G

PL/SQL: ORA-21700 object does not exist. . . Oracle10g to SDE 10/Oracle11G

How to tell if feature class is registered with Move Edits To Base

How to tell if feature class is registered with Move Edits To Base