RohitBorse
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: How to send oracle to_date function in groovy sql.call.
Ok, I have done something below import groovy.sql.Sql; import groovy.sql.GroovyRowResult; GroovyRowResult row = sql.firstRow("SELECT to_date('2021-04-28-00.00.00','YYYY-MM-DD-HH24.MI.SS','NLS_CALENDAR=GREGORIAN') AS MyDate FROM DUAL"); def MyDate= row.MyDate; String RESULT = ""; sql.call( "{call MYAPP.MYDATE.UPDATE_DATE(?, ?)}", [ sql.inout(Sql.VARCHAR(RESULT), MyDate]) {OUT1 -> RESULT = OUT1; }876Views0likes0Comments