List at least three common ways to write logs in PL SQL?
yogesh
Aug 4th, 2011
We can't return more than 1 value in function but by using OUT parameter we can get multiple values in function
which is not good programming, by using ref cursor we just save memory location of function doesn't return more than 1 value.
1. Create a log table and insert your logging messages into this table.2. Write to a log file, using the DBMS_FILE package, but this is not recomended because there is lot of I/O.