Hi
We are trying to execute a user defined sql using bind variable in "before" option in the SQL tab in OCI stage.
Our requirement was to delete all the rows in the target table that matches to the input "report_date" before loading into target table.
Hence,we are running user defined sql in the "before" option in SQl tab in target OCI stage.
DELETE FROM DW_TRAVEL.AMEX_ABA_CAK_AIRLINE WHERE TRUNC(REPORT_DATE) =TO_DATE(:5,'YYYY-MM-DD')
It was givng below error.
ORA-01008: not all variables bound
However,when I run the same statement in oracle.it deleted the rows.
For example : We had run the below statement in oracle.
DELETE FROM DW_TRAVEL.AMEX_ABA_CAK_AIRLINE WHERE TRUNC(REPORT_DATE) =TO_DATE('2011-07-01','YYYY-MM-DD')
However in the OCI stage,we have used bind variable :5 for the input report_date which has value stored as '2011-07-01' field which resulted in the error.
Can anyone has any idea why we are getting this error?
Thanks
Kiran
ORA-01008: not all variables bound : error while deleting
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am