PlugIns JdbcSlim UserGuide 4TheMappingBetweenTestDataAndCommands StoredProcedures
| Script | SQLCommand | TestDatabase |
| open Connection | ||
| execute | create alias IF NOT EXISTS selectStar for "six42.fitnesse.jdbcslim.SampleStoredProcedure.showTestData" | |
| show | success | |
| show | rawResult | |
| show | resultSheet | |
| execute | create alias IF NOT EXISTS myQuery for "six42.fitnesse.jdbcslim.SampleStoredProcedure.myquery" | |
| show | success | |
| show | rawResult | |
| show | resultSheet | |
| close Connection | ||
| SQLCommand | TestDatabase | call myquery('select * from TestData where Profession = ''Milkman''') | QUERY | |
| ID | Name | Phone | City | Profession |
| 3 | Tom | 4567890 | Seoul | Milkman |