HI,
I have an issue.When i use Oracle OCI instead of DRS i am getting the error "ORA 00911,Invalid character".I observed that this is only because of the following code.
AND (PS_JRNL_HEADER.LASTUPD_EW_DTTM > %DateTimeIn('#LastModifiedDateTime#')
OR PS_JRNL_HEADER.LASTUPD_EW_DTTM Is Null
OR PS_JRNL_LN.LASTUPD_EW_DTTM > %DateTimeIn('#LastModifiedDateTime#')
OR PS_JRNL_LN.LASTUPD_EW_DTTM Is Null)
May I know where I am going wrong.
THe same code If i write in DRS,It so OK.The error is coming only if I use Oracle OCI..
,.............LTRIM(RTRIM(PS_JRNL_HEADER.LEDGER)),TO_CHAR(PS_JRNL_HEADER.UNPOST_JRNL_DATE, 'YYYY-MM-DD HH24:MI:SS'),LTRIM(RTRIM(PS_JRNL_HEADER.JRNL_HDR_STATUS)),TO_CHAR(PS_JRNL_HEADER.POSTED_DATE, 'YYYY-MM-DD HH24:MI:SS'),RESOURCE_TYPE,RESOURCE_CATEGORY FROM #$OWS_SCHEMA#PS_JRNL_LN PS_JRNL_LN,#$OWS_SCHEMA#PS_JRNL_HEADER PS_JRNL_HEADER WHERE PS_JRNL_HEADER.BUSINESS_UNIT = PS_JRNL_LN.BUSINESS_UNIT
AND PS_JRNL_HEADER.SRC_SYS_ID = PS_JRNL_LN.SRC_SYS_ID
AND PS_JRNL_HEADER.JOURNAL_ID = PS_JRNL_LN.JOURNAL_ID
AND PS_JRNL_HEADER.JOURNAL_DATE = PS_JRNL_LN.JOURNAL_DATE
AND PS_JRNL_HEADER.UNPOST_SEQ = PS_JRNL_LN.UNPOST_SEQ
AND (PS_JRNL_HEADER.LASTUPD_EW_DTTM > %DateTimeIn('#LastModifiedDateTime#')
OR PS_JRNL_HEADER.LASTUPD_EW_DTTM Is Null
OR PS_JRNL_LN.LASTUPD_EW_DTTM > %DateTimeIn('#LastModifiedDateTime#')
OR PS_JRNL_LN.LASTUPD_EW_DTTM Is Null)
Value is which i have entered is 1900-01-01 00:00:00
Assuming all of your parameters are properly resolving, the 'illegal character' is the percent sign. What is %DateTimeIn() supposed to be, a stored function?
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:Assuming all of your parameters are properly resolving, the 'illegal character' is the percent sign. What is %DateTimeIn() supposed to be, a stored function? ...