Bind variables in BI Data definition
Hi
i am passing parameters via cc request to be used to get a start/end date for my main query. The passed parms com in ok but my bind variables that i am tying to create seem not to be created. i keep getting this error
XDO Data Engine Version No: 5.6.3 Resp: 50549 Org ID : 101 Request ID: 2279064 All Parameters: P_MONTH=MAY:P_YEAR=2011 Data Template Code: TNMC_653_OPEN Data Template Application Short Name: XX_CUST Debug Flag: N {P_MONTH=MAY, P_YEAR=2011} Calling XDO Data Engine... [101711_015538928][][ERROR] Variable 'START_DATE' is missing.... [101711_015538928][][EXCEPTION] java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification>
i am passing parameters via cc request to be used to get a start/end date for my main query. The passed parms com in ok but my bind variables that i am tying to create seem not to be created. i keep getting this error
XDO Data Engine Version No: 5.6.3 Resp: 50549 Org ID : 101 Request ID: 2279064 All Parameters: P_MONTH=MAY:P_YEAR=2011 Data Template Code: TNMC_653_OPEN Data Template Application Short Name: XX_CUST Debug Flag: N {P_MONTH=MAY, P_YEAR=2011} Calling XDO Data Engine... [101711_015538928][][ERROR] Variable 'START_DATE' is missing.... [101711_015538928][][EXCEPTION] java.sql.SQLException: ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "." when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification>
0