SELECT * will not work with table containing geodata

08-25-2020 02:11 PM
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:

0 Kudos
0 Replies