Hi,

I've made a custom db collector. When I run it I get a ORA-00923: FROM
keyword not found where expected error in the collection manager log.
The sql I use ing sqlquery.base is

SELECT
invoke_time, Date_started, date_ended, orderno, User_id, Report_id
FROM PRHR01_AGR01.ACRREPORD
WHERE invoke_time > TO_TIMESTAMP ('%s', 'RRRR-MM-DD HH24:MI:SS')
ORDER BY invoke_time

This sql works just fine in SQL Developer.

I also get alot of repeating row_left=-1. 30+ in a minute. Is this
normal.

--
Frode


--
fsjovatsen
------------------------------------------------------------------------
fsjovatsen's Profile: http://forums.novell.com/member.php?userid=9767
View this thread: http://forums.novell.com/showthread.php?t=451094