I am having an issue with a user defined sql query using an ORAOCI8 stage.
The query is as follows:
Code: Select all
INSERT INTO
TABLE_1
SELECT
:1 AS TRANSACTION_ID,
:2 AS TRANSACTION_RELATIONSHIP_CODE,
:3 AS BEFORE_OR_AFTER_IMAGE,
CUSTOMER_ID,
CUSTOMER_TYPE,
CUSTOMER_STATUS_CODE,
CUSTOMER_UPDATED
FROM
(SELECT
DISTINCT TABLE_2.*
FROM
CUSTOMER JOIN OPERATOR ON CUSTOMER_ID = OPERATOR_ID
WHERE
CONTROLLED_OBJECT_ID = :4
Oracle stage settings: Array size: 1000, Rows per transaction: 0
I have run the query in the database and it works fine.
I have also recreated the job in dev environment and it works fine there too. I cannot recreate the same error.
Does anybody have any thoughts as to what is causing this problem? I am thinking about just rebuilding that particular stream to see if it goes away.
thanks in advance
Shane