查看PL/SQL编译时的错误信息(转)
编译无效对象是DBA与数据库开发人员常见的工作之一。对于编译过程中的错误该如何去捕获，下面给出两种捕获错误的方法。
一、当前数据库版本信息及无效对象
1、查看当前数据库版本
</p><p>二、捕获编译错误<br> 1、使用show errors捕获错误 </p><p><textarea name="code" or "JAVA CLASS" SEQUENCE NUMBER Sequence number used for ordering purposes LINE NUMBER Line number at which this error occurs POSITION NUMBER Position in the line at which this error occurs TEXT VARCHAR2(4000) Text of the error ATTRIBUTE VARCHAR2(9) Y MESSAGE_NUMBER NUMBER Y SQL> select owner,name,TEXT from dba_errors where owner='OTC_WRHS_POSITION' and name='OTC_WRHS_POSITION_PCK_tmp' and 2 sequence=(select max(sequence) from dba_errors where owner='OTC_WRHS_POSITION'); OWNER NAME TEXT -------------------- ------------------------- ------------------------ OTC_WRHS_POSITION OTC_WRHS_POSITION_PCK_tmp PLS-00103: Encountered the symbol "ULL" when expecting one o f the following: . ( ) , * @ % & = - + < / > at in is mod remainder not re m <an exponent (**)> <> or != or ~= >= <= <> and or like LI KE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ The symbol "." was substituted for "ULL" to continue.
?
