Informatica level:
This error will occur when ever u have added/connected columns from SQ t/r to target but those columns are not available in the SQl over ride then session get failed because of this error.
solution:
from SQ t/r click on generate SQL and add the same query in the session level SQl override,then execuite the session.
in my case i have added more columns in the mapping level SQ t/r to exp t/r but those columns are not added in the session level SQ over ride query because of that session get failed with this error and i have added those new columns in the session level sql override query. session get success.
solution:
from SQ t/r click on generate SQL and add the same query in the session level SQl override,then execuite the session.
in my case i have added more columns in the mapping level SQ t/r to exp t/r but those columns are not added in the session level SQ over ride query because of that session get failed with this error and i have added those new columns in the session level sql override query. session get success.
oracle level :
As far as I knew, this message can appear when:
- The error causing ORA-01007 is in OCI, if the number of variables is greater in theSELECT clause than the number of passed variables number passed in the position parameter.
- In SQL*Report or SQL*Forms, if you have lass values in the SELECT clause, than you specified in theINTO clause
No comments:
Post a Comment