PL/SQL UNION语句报错求助：ORA-00936等错误排查

云上老周

2026-5-8

解决PL/SQL中SEARCH_CLIENT函数的UNION语法错误

嘿，我看你在SQL Developer里写PL/SQL的搜索函数时碰到了ORA-00936: missing expression和PL/SQL: SQL Statement ignored的错误，这问题我之前也踩过坑，咱们来一步步搞定它～

错误原因分析

你写的函数里有两个关键问题：

参数引用错误：你写的LIKE '%name%'里的name是字符串字面量，数据库会把它当成固定字符串"name"去匹配，而不是你传入的函数参数。
UNION语法位置错误：OPEN rc FOR后面需要跟一个完整的SQL查询语句，但你在第一个SELECT结束后直接加了UNION，导致SQL语句结构断裂，数据库无法识别完整的查询逻辑。

修正后的函数代码

FUNCTION SEARCH_CLIENT(name IN VARCHAR2) RETURN SYS_REFCURSOR 
IS 
    rc SYS_REFCURSOR; 
BEGIN 
    OPEN rc FOR 
        SELECT * FROM clients WHERE Name LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE Number LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE Company LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE Address LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE CompanyId LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE InvoiceAddress LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE Worker_name LIKE '%' || name || '%'
        UNION 
        SELECT * FROM clients WHERE PostNumber LIKE '%' || name || '%';
    RETURN rc; 
END SEARCH_CLIENT;