错误码 / Oracle Database

Oracle Database 错误码 PLS-00204

function or pseudo-column ' string ' may be used inside a SQL statement only 原因:A pseudocolumn or proscribed function was used in a procedural stateme…

错误说明

function or pseudo-column ' string ' may be used inside a SQL statement only

原因:A pseudocolumn or proscribed function was used in a procedural statement. The SQL pseudocolumns (LEVEL, ROWID, ROWNUM) can be used only in SQL statements. Likewise, certain functions such as DECODE, DUMP, and VSIZE and the SQL group functions (AVG, MIN, MAX, COUNT, SUM, STDDEV, VARIANCE) can be used only in SQL statements.

处理:Remove the pseudocolumn reference or function call from the procedural statement. Or, replace the procedural statement with a SELECT INTO statement; for example, replace bonus := DECODE(rating, 1, 5000, 2, 2500, ...); with the following statement: SELECT DECODE(rating, 1, 5000, 2, 2500, ...) INTO bonus FROM dual;

官方文档

进一步检索

相关错误码