SELECT * will not work with table containing geodata

377
0
08-25-2020 02:11 PM
CamCode
New Contributor III

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..

$sql = 'SELECT * FROM app.table_1';

however, this will work (specifying a column name, i.e. objectid😞

$sql = 'SELECT objectid FROM app.table_1';

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-c...

0 Kudos
0 Replies