PL SQL Logs

List at least three common ways to write logs in PL SQL?

Questions by liaohanming

Showing Answers 1 - 9 of 9 Answers

sububhaai

  • May 14th, 2009
 


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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions