And then switch session and query table debugs with debug

Chapter 7 ■ troubleshooting

Listing 7-11 is a test unit for package DEBUG_OTS that turns debug logging on then off, repeating the same test twice.

old 4: where unique_session_id = upper('&unique_session_id') new 4: where unique_session_id = upper('000487240001')

ID TEXT
---------- ---------------------------------------------------- 225 before the loop
226 loop 1 before sleep
227 loop 1 after sleep
228 loop 2 before sleep

old 4: where unique_session_id = upper('&unique_session_id') new 4: where unique_session_id = upper('000487240001')

ID TEXT
---------- ---------------------------------------------------- 225 before the loop
226 loop 1 before sleep
227 loop 1 after sleep
228 loop 2 before sleep
229 loop 2 after sleep
230 loop 3 before sleep
231 loop 3 after sleep
232 loop 4 before sleep
233 loop 4 after sleep
234 loop 5 before sleep
235 loop 5 after sleep
236 loop 6 before sleep
237 loop 6 after sleep
238 loop 7 before sleep
239 loop 7 after sleep
240 loop 8 before sleep
241 loop 8 after sleep
242 loop 9 before sleep
243 loop 9 after sleep
244 loop 10 before sleep
245 loop 10 after sleep
246 after the loop

Your assignment is to create a relational debug table and table package that incorporate the same functionality as the object-relational example I just showed you. Yes, you should also include the test unit. Follow these steps.

1. Write a DDL script to create a relational table called DEBUGS with the same columns as the attributes found in TYPE DEBUG.