I have a oracle table with geodata in it... Anyone experience this?
And the following will not run... I get ORA-00932 error every time..
<SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">$</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">sql </SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">=</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;"> </SPAN><SPAN class="" style="color: var(--red-800); border: 0px; font-weight: inherit; font-size: 13px;">'SELECT * FROM app.table_1'</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">;</SPAN>
however, this will work (specifying a column name, i.e. objectid😞
<SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">$</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">sql </SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">=</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;"> </SPAN><SPAN class="" style="color: var(--red-800); border: 0px; font-weight: inherit; font-size: 13px;">'SELECT objectid FROM app.table_1'</SPAN><SPAN class="" style="color: var(--black-750); border: 0px; font-weight: inherit; font-size: 13px;">;</SPAN>
Seeing as I have a table with ~100 columns I do not want to manually hardcode out a list of the columns for this query.. anybody experience this?
legacy question: https://stackoverflow.com/questions/63562690/cant-select-ora-00932-inconsistent-datatypes-expected-char-got-adt
