Just another way of debug logging in Oracle PL/SQL
来源:互联网 发布:美食卡 yum 编辑:程序博客网 时间:2024/06/03 14:00
SQL> create directory log_test as 'c:\ken\sql\learning';
Directory created.
SQL> grant read,write on directory log_test to public;
Grant succeeded.
FileLogTest.sql
=================
CREATE OR REPLACE PROCEDURE fileLog
AS
fileHandle UTL_FILE.FILE_TYPE;
BEGIN
fileHandle := UTL_FILE.fopen('LOG_TEST', 'log.txt', 'a', 1024); -- Pay attention to the case for the directory here (UPPER CASE)
UTL_FILE.put_line(fileHandle, 'testing...', TRUE);
UTL_FILE.fclose(fileHandle);
END;
/
Reference
http://psoug.org/reference/utl_file.html
- Just another way of debug logging in Oracle PL/SQL
- Think in another way【Matrix67】
- yii分析 Yii: Just another way to use GridView
- Using of REF CURSOR in PL/SQL
- Samples of PL/SQL in JDBC
- Another way to HOOK in the kernel
- Another way to HOOK in the kernel
- Another way to HOOK in the kernel
- Oracle PL/SQL之IN OUT NOCOPY
- Enable trace 10046 in Oracle PL/SQL
- PL/SQL Debug
- PL/SQL debug
- oracle pl/sql存储过程的调试(debug)
- In the way of SSM
- One case of DDL executed in PL/SQL
- PL/SQL登陆不成功!出现no logging
- PL/SQL DEV Debug问题
- Overview of PL/SQL
- 【设计模式攻略】行为型模式之Null Object模式
- 在Windows Server 2008R2中安装配置SMTP服务
- 在qemu的beagleboard上运行android
- 学习动态性能表(三)-(1)-v$sql
- Building a Jabber Client for iOS: XMPP Setup
- Just another way of debug logging in Oracle PL/SQL
- Windows Server 2008远程桌面多用户登陆的配置方法
- 学习网址记录
- 是消极悲观,还是乐观进取
- flex4 3DColumnChart
- hibernate中inverse的用法
- JS三个等于号
- 这世界有两种人——积极的人和消极的人。
- 编写一个函数 找出double类型中最大数的下标 输出下标