https://blog.youkuaiyun.com/chiskyzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/chisky/article/details/7493750https://blog.youkuaiyun.com/chisky/article/details/7493750chiskyTue, 24 Apr 2012 14:55:40 +0800 ALTER SYSTEM SET trace_enabled = TRUE; 然后依次执行以下命令: 1. alter session set max_dump_file_size='UNLIMITED';]]>https://blog.youkuaiyun.com/chisky/article/details/7476732https://blog.youkuaiyun.com/chisky/article/details/7476732chiskyThu, 19 Apr 2012 11:14:09 +0800https://blog.youkuaiyun.com/chisky/article/details/7333084https://blog.youkuaiyun.com/chisky/article/details/7333084chiskyThu, 08 Mar 2012 15:32:29 +0800https://blog.youkuaiyun.com/chisky/article/details/7222677https://blog.youkuaiyun.com/chisky/article/details/7222677chiskyTue, 31 Jan 2012 17:24:49 +0800https://blog.youkuaiyun.com/chisky/article/details/7222670https://blog.youkuaiyun.com/chisky/article/details/7222670chiskyTue, 31 Jan 2012 17:22:23 +0800https://blog.youkuaiyun.com/chisky/article/details/7222658https://blog.youkuaiyun.com/chisky/article/details/7222658chiskyTue, 31 Jan 2012 17:20:45 +0800https://blog.youkuaiyun.com/chisky/article/details/6972924https://blog.youkuaiyun.com/chisky/article/details/6972924chiskyTue, 15 Nov 2011 14:30:27 +0800https://blog.youkuaiyun.com/chisky/article/details/6972874https://blog.youkuaiyun.com/chisky/article/details/6972874chiskyTue, 15 Nov 2011 14:25:21 +0800connect /as sysdba) run SQL> @utlxplan  run SQL> create public synonym plan_table for plan_table  r]]>https://blog.youkuaiyun.com/chisky/article/details/6972849https://blog.youkuaiyun.com/chisky/article/details/6972849chiskyTue, 15 Nov 2011 14:10:00 +0800https://blog.youkuaiyun.com/chisky/article/details/6972829https://blog.youkuaiyun.com/chisky/article/details/6972829chiskyTue, 15 Nov 2011 14:04:54 +0800https://blog.youkuaiyun.com/chisky/article/details/6948394https://blog.youkuaiyun.com/chisky/article/details/6948394chiskyTue, 08 Nov 2011 15:47:47 +0800https://blog.youkuaiyun.com/chisky/article/details/6733595https://blog.youkuaiyun.com/chisky/article/details/6733595chiskyTue, 30 Aug 2011 19:40:07 +0800https://blog.youkuaiyun.com/chisky/article/details/6702639https://blog.youkuaiyun.com/chisky/article/details/6702639chiskyFri, 19 Aug 2011 17:50:09 +0800https://blog.youkuaiyun.com/chisky/article/details/6699092https://blog.youkuaiyun.com/chisky/article/details/6699092chiskyThu, 18 Aug 2011 17:55:46 +0800https://blog.youkuaiyun.com/chisky/article/details/6551778https://blog.youkuaiyun.com/chisky/article/details/6551778chiskyFri, 17 Jun 2011 14:37:00 +0800https://blog.youkuaiyun.com/chisky/article/details/6546246https://blog.youkuaiyun.com/chisky/article/details/6546246chiskyWed, 15 Jun 2011 14:56:00 +0800https://blog.youkuaiyun.com/chisky/article/details/6546166https://blog.youkuaiyun.com/chisky/article/details/6546166chiskyWed, 15 Jun 2011 14:36:00 +0800https://blog.youkuaiyun.com/chisky/article/details/6535855https://blog.youkuaiyun.com/chisky/article/details/6535855chiskyFri, 10 Jun 2011 10:37:00 +0800https://blog.youkuaiyun.com/chisky/article/details/6265721https://blog.youkuaiyun.com/chisky/article/details/6265721chiskyMon, 21 Mar 2011 18:22:00 +0800在Oracle Reports中使用'Execute Immediate'

在Oracle Reports中直接使用'Execute Immediate'是不允许的,但是可以在数据库中建立一个存储过程,然后在Oracle Reports中调用这个存储过程来达到执行SQL语句的目的.


在数据库中建立存储过程如下:
 
CREATE OR REPLACE PROCEDURE DYNAMIC_SQL(STMNT c]]>https://blog.youkuaiyun.com/chisky/article/details/6156450https://blog.youkuaiyun.com/chisky/article/details/6156450chiskyFri, 21 Jan 2011 10:40:00 +0800这次在64位的linux系统上安装EBS，在APPL_TOP成功安装完成后出现无法启动的问题，检查日志发现了如下错误：
 
libclntsh.so.10.1: cannot open shared object file: No such file or directory
 
在网上搜索后主要的解决办法就是用ldconfig， 把libclntsh.so.10.1加到/etc/ld.so.conf文件里，这种办法试了几次后还是没有结果，错误仍然存在。<]]>