Forum Discussion
nmrao
Champion Level 3
Please see if the below helps:
def queryTemplate = """Select ${#Project#GP_DBName_1}.MARKETS.ID From ${#Project#GP_DBName_1}.MARKETS where ${#Project#GP_DBName_1}.MARKETS.EVENTID = ${#TestCase#eventId} And (RTRIM(UPPER(${#Project#GP_DBName_1}.MARKETS.DESCRIPTION)) = RTRIM(UPPER(\'${#TestCase#marketType}\')) OR ${#Project#GP_DBName_1}.MARKETS.MARKETTYPEID = ${#TestCase#marketTypeId})""" def query = context.expand(queryTemplate) log.info "Final query is :\n $query" //Now pass the above "query" object to sql to execute
raiqee
7 years agoOccasional Contributor
Hi Rao,
We tried the solution you provided but we encountered a new error, tried running it on soapui
Thu May 04 15:45:21 CST 2017:ERROR:An error occurred [ORA-00942: table or view does not exist
], see error log for details
- nmrao7 years agoChampion Level 3From log statement you can validate if the query is correct or not. Isn't it? Have you looked at it?
Related Content
- 6 years agodrwohlers
- 3 years agoFederated_Mutua