user709772 wrote:If the variable is a date/charcter type variable then it should be enclosed within single quoats
I'm using a date variable as a interface filter. when I execute the interface, the variable is not being replaced with it's value. Receiving a Java sql error: Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
Is there a setting I've missed for the variable to render when the interface is executed? The first time I ran the interface with the variable it worked, but consecutive executions of the interface is no longer replacing the data variables value.
The session code clearly shows the variable not being replaced with the date variable's value: And (TRUNC(PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE) >= #OAL_CENTAL_ODI_HUB.D_OALHCM_EFFDT)
user709772 wrote:This may be because your project name is OAL_CENTRAL_ODI_HUB
I've setup a package to execute the variable refresh and interface and set the filter variable to use the colon. I noticed something odd in the execution's session code. When I prefix the variable in the filter with a colon, I don't receive the IN/Out error, but the session code is not substituting the project name correctly nor do I see the variable value used the session code.
Example: Project name: OAL_CENTRAL_ODI_HUB
Variable name: D_OALHCM_EFFDT
Interface Filter: TRUNC(PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE) >= :D_OALHCM_EFFDT
When pkg is executed, the session step's code shows this:
And (TRUNC(PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE) >= :OAL_CENTAL_ODI_HUB.D_OALHCM_EFFDT)
It should show this:
And (TRUNC(PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE) >= :OAL_CENTRAL_ODI_HUB.D_OALHCM_EFFDT)
So, the session code is missing the letter 'R' in 'CENTRAL'
Also, from the sesssion code, I would have expected to have seen the variable replaced by its value not the variable name. So in this case, I should have seen this:(right?)
And (TRUNC(PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE) >= '01-nov-2012')
I don't understand why the execution is mis-naming the project name. I switched the variable back to use # and it's doing the same thing.
So, I'm still not seeing the variable work.