ResultSet = Statement.executeQuery (StatementSQL)
With StatementSQL equaling
SELECT * from table (cwms.ghk_test.retrieve_ts ( 'ft', 'NWD', 'FTPK-Fort Peck Dam-Missouri.Elev.Inst.1Hour.0.mrrppcs-rev', TO_DATE ('11Feb2008 00:00', 'DDMONYYYY HH24:MI'), TO_DATE ('11Feb2008 00:00', 'DDMONYYYY HH24:MI'), 'America/Regina'))
Note: For somereason it works fine inside the my toad software. Also other sqlstatements work so doesn't seem to be the connection.
Does anyone know if you have to give custom packages additional privilages in oracle to get them to work in STAROFFICE basic?

Running on Windows XP and Oracle 10.2.3, using ODBC connection.