I've got a dblink to a sqlite database and I have created s stored procedure that runs some update scripts. the statements read from sqlite and update some tables in my oracle database. It works fin in the sqldeveloper. The following statement never fails:
begin my_package.tidyUpPreImport(); end;
I have created a scheduled job to have it run every early morning. but the job always fails with the following errors.
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from SQLITE
ORA-06512: at "my_user.my_package", line 69
How can I have it run as a job successfully?
This is my job:
OWNER: my_user
JOB_NAME: udJobTidyUpPreImport
JOB_CLASS: DEFAULT_JOB_CLASS
COMMENTS: Tägliche Vorbereitung des GIS-Imports
ENABLED: TRUE
CREDENTIAL:_NAME
DESTINATION:
PROGRAM_NAME:
JOB_TYPE: STORED_PROCEDURE
JOB_ACTION: my_user.my_package.tidyUpPreImport
NUMBER_OF_ARGUMENTS: 0
SCHEDULE_OWNER:
SCHEDULE_NAME:
SCHEDULE_TYPE: CALENDAR
START_DATE: 26.09.18 15:26:41,025000000 EUROPE/BERLIN
REPEAT_INTERVAL: FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=0;BYMINUTE=30;BYSECOND=0
END_DATE:
EVENT_QUEUE_OWNER:
EVENT_QUEUE_NAME:
EVENT_QUEUE_AGENT:
EVENT_CONDITION:
FILE_WATCHER_OWNER:
FILE_WATCHER_NAME:
All other scheduled jobs, that call procedures in this package work fine. But they do not use dblinks.