| animumbai |
Posted: Apr 09, 2008 11:10:25 AM |
Total Post: 9
Joined: Dec, 2007
|
hi All,
as per the requirment i need the procedure based on the UTIL_package.This is because to create the log file. For example when the procedure executed in the oracle.. it has to trace the out put. can any one help me |
|
|
 Murtuja |
| Posted: Apr 10, 2008 01:17:52 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
DBMS_TRACE
see below link
http://www.cs.umbc.edu/help/oracle8/server.815/a68001/dbms_tra.htm
|
|
|
|
|
| animumbai |
| Posted: Apr 11, 2008 05:29:37 AM | |
|
Total Post: 9
Joined: Dec, 2007
|
hi murtuja thanks for sending link... but can u send the procedure for creating log and then how i can call and declare that into other remaining procedure which is used for the development.while running procedure
|
|
|
|
|
| animumbai |
| Posted: Apr 26, 2008 07:16:16 AM | |
|
Total Post: 9
Joined: Dec, 2007
|
hi All, anyone call help me how i can trace the log which is to be stored in the file. whatever the procedure is executed in the database....
whether it may be in util.package is very useful or any other methods.
Pls can u send any procedure for creating file in the directory and then it has to read or write the file wt ever the procedure executed is should trace...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
