ora-06550 PLS-00553 PL/SQL: Compilation unit analysis terminated

在做一个比较任重道远的事情，结果在过程中总是被其他事情打断，前几天又是被打断了，说是我写的一个报表的查询效能不好，所以要求改善，在Sql/plus 里面执行我的Sql发现效能也就在1秒以内，可是到程序里面就有问题了，所以怀疑是iis server的问题，于是想将程序搬到另一台server也就是后来我碰到标题问题的这台上测试，又因为oracle9i 的odbc有问题，所以将这台server上的9i client删除装了oracle817测试完了后，发现我要做的任重道远的事情的东西不能用了，select 的时候总是提示:ora-06550 PLS-00553 PL/SQL: Compilation unit analysis terminated 困扰我好几天，在这片文章中找到了答案.....（连自己都佩服自己的耐性，因为这篇文章的最后面才会有一句话提醒了我，解决了问题，我都一个个看过来了）

[@more@]

timestamp datatype [message #138929] Sun, 25 September 2005 21:16 lavanya_pvn Messages: 11 Registered: September 2005 Junior Member hi.... when we create a table with timestamp datatype ....and the column name also as timestamp its created and we can perform all the operations on the table i.e, create table a (timestamp timestamp); but if we use this table in a trigger it is giving 'trigger created with compilation errors' , why? Report message to a moderator

Re: timestamp datatype [message #138997 is a reply to message #138929 ] Mon, 26 September 2005 05:00 saadatahmad Messages: 356 Registered: March 2005 Location: Kuwait Senior Member hi, Please read the sticky. You should also provide the code if you'r getting the error message and the version of Oracle database. Check this: saadat@anba> SELECT * FROM v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production Elapsed: 00:00:00.02 saadat@anba> CREATE TABLE test 2 ( a TIMESTAMP); Table created. Elapsed: 00:00:00.00 saadat@anba> CREATE OR REPLACE TRIGGER trg_test 2 AFTER INSERT ON test 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Trigger fired successfully'); 5 END; 6 / Trigger created. Elapsed: 00:00:00.00 saadat@anba> INSERT INTO test 2 VALUES('09-JAN-2006'); Trigger fired successfully 1 row created. Elapsed: 00:00:00.00 saadat@anba> COMMIT; Commit complete. Elapsed: 00:00:00.00 saadat@anba> SELECT * FROM test; A --------------------------------------------------------------------------- 09-JAN-20 06.00.00.000000 AM Elapsed: 00:00:00.00 saadat@anba> It doesn't give the error. You have to check the error you'r receiving by the command SHOW ERRORS Regards Report message to a moderator

Re: timestamp datatype [message #139011 is a reply to message #138929 ] Mon, 26 September 2005 05:17