Oracle SQL and ST_RASTER some functions work, others don't.

SteveTest — Wed, 29 May 2013 11:02:13 GMT

Hi

I can issue SQL such as:

SELECT D.raster.describe() FROM owner.rastertable D;

And the results are fine.

However when I get down to nitty gritty details such as fetching a pixel value, the query fails with errors.

e.g.

SELECT t.raster.getValue(1,10,10,10) r
FROM owner.rastertable t;

RA-29400: data cartridge error
SdeCursor::execute()
ORA-00942: table or view does not exist
ORA-06512: at "SDE.ST_RASTER", line 338
ORA-06512: at "SDE.ST_RASTER", line 627
29400. 00000 - "data cartridge error\n%s"
*Cause:    An error has occurred in a data cartridge external procedure.
           This message will be followed by a second message giving
           more details about the data cartridge error.
*Action:   See the data cartridge documentation
           for an explanation of the second error message.

Note the owner.rastertable referenced above is exactly the same table that can be successfully described with:

SELECT D.raster.describe() FROM owner.rastertable D;

Any help or ideas appreciated!

Re: Oracle SQL and ST_RASTER some functions work, others don't.

VinceAngelo — Wed, 29 May 2013 13:13:03 GMT

That looks like your raster packages are not properly configured with Oracle
('describe' isn't as likely to need to drill into the package as pixel extraction).

You probably want to review the install doc and verify that the DLL is visible
as a library in the same location as within the Listener.

- V

topic Re: Oracle SQL and ST_RASTER some functions work, others don't. in Data Management Questions

Oracle SQL and ST_RASTER some functions work, others don't.

Re: Oracle SQL and ST_RASTER some functions work, others don't.