I want to create a spatial view that draws a buffer around my input features, like this: SELECT a . OBJECTID , sde . st_buffer ( a . SHAPE , 33 ) as SHAPE FROM schemaname . tablename a WHERE OBJECTID IS NOT NULL I get the following errors: Any ideas what the problem could be? Geodatabase version 10.3; Oracle version 12.1.0.2. Configured according to this doc.

So this is how it looks in ArcMap and I believe this is what you wanted..

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

simple sde.st_buffer spatial view, ORA errors

TobiasFimpel

I want to create a spatial view that draws a buffer around my input features, like this:

<SPAN class="keyword token">SELECT</SPAN> 
<SPAN class="number token">a</SPAN><SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="punctuation token">,</SPAN>
sde<SPAN class="punctuation token">.</SPAN>st_buffer <SPAN class="punctuation token">(</SPAN><SPAN class="number token">a</SPAN><SPAN class="punctuation token">.</SPAN>SHAPE<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">33</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> SHAPE
<SPAN class="keyword token">FROM</SPAN> schemaname<SPAN class="punctuation token">.</SPAN>tablename <SPAN class="number token">a</SPAN>
<SPAN class="keyword token">WHERE</SPAN> OBJECTID <SPAN class="operator token">IS</SPAN> <SPAN class="operator token">NOT</SPAN> <SPAN class="token boolean">NULL</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I get the following errors:

Any ideas what the problem could be?

Geodatabase version 10.3; Oracle version 12.1.0.2. Configured according to this doc.

Vind meer berichten getagd met

Accepted answers

All comments

bixb0012

Thanks for sharing the resolution.

TobiasFimpel

Just to close this thread: it turned out that our libst_shapelib file was quite old. After we replaced it with a more recent one the error does not appear.

TobiasFimpel

Ok, so it is possible. Thank you.

I had to 'GRANT INHERENT PRIVILEGES ON ...' to get even your simple test query to work. Now I guess I have to look further....

Asrujit_SenGupta

Tobias

Error: ORA-06598: insufficient INHERIT PRIVILEGES privilege" during Oracle 12c Data Pump import this Article mentions about database Restore issues, so it should not be related to your problem.

As I mentioned in my first Post, I tried the same SQL that you are using and it works as expected and I can see the View in ArcMap. So using it in ArcGIS Server should work as well.

<SPAN class="keyword token">SELECT</SPAN> <SPAN class="number token">a</SPAN><SPAN class="punctuation token">.</SPAN>OBJECTID<SPAN class="punctuation token">,</SPAN> sde<SPAN class="punctuation token">.</SPAN>st_buffer <SPAN class="punctuation token">(</SPAN><SPAN class="number token">a</SPAN><SPAN class="punctuation token">.</SPAN>SHAPE<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">65</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> SHAPE
<SPAN class="keyword token">FROM</SPAN> sde<SPAN class="punctuation token">.</SPAN>Testdata <SPAN class="number token">a</SPAN>
<SPAN class="keyword token">WHERE</SPAN> OBJECTID <SPAN class="operator token">IS</SPAN> <SPAN class="operator token">NOT</SPAN> <SPAN class="token boolean">NULL</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I used the above and it works perfectly.

I was using Oracle 11.2.0.4 and a 10.2.1 geodatabase for the quick test, which was readily available to me.

TobiasFimpel

Thank you for your reply Asrujit. I found this Esri doc. that describes a configuration consideration with Oracle 12: http://support.esri.com/en/technical-article/000012391

Your test query (...from dual) works now. My view still fails with the same error, but I'm actually not sure anymore that Esri can create new geometries (e.g. buffer) via spatial views that I can then consume in ArcMap/ArcGIS Server.

Asrujit_SenGupta

Make sure the Extproc was configured correctly. I just ran a quick test and it is working fine.

Connect as SDE in SQLPlus and execute the below query. If it gives you an error instead of returning a result as below, the Extproc has not been configured correctly then:

SQL<SPAN class="operator token">></SPAN> <SPAN class="keyword token">select</SPAN> sde<SPAN class="punctuation token">.</SPAN>ST_AsText<SPAN class="punctuation token">(</SPAN>SDE<SPAN class="punctuation token">.</SPAN>ST_Geometry<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'POINT (10 10)'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">from</SPAN> dual<SPAN class="punctuation token">;</SPAN>

SDE<SPAN class="punctuation token">.</SPAN>ST_ASTEXT<SPAN class="punctuation token">(</SPAN>SDE<SPAN class="punctuation token">.</SPAN>ST_GEOMETRY<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'POINT(1010)'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">--------------------------------------------------------------------------------</SPAN>

<SPAN class="keyword token">POINT</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN> <SPAN class="number token">10.00000000</SPAN> <SPAN class="number token">10.00000000</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

https://community.esri.com/community/gis/managing-data?sr=search&searchId=f8869f23-d604-4c6c-8ccc-7f8fdb05ba21&searchIndex=0‌

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Alle Gemeenschappen
Recente Berichten
Gevolgde Inhoud
Community Hulp

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.