oracle - ORA-01747 错误 user.table.column、table.column 或列规范无效

Question

我在 sqldevelopers 中编写了这个过程，我想我收到了这个错误，因为字段：“no”和“year”是保留字我试图用括号来修复它，但它似乎没有帮助......希望你能提供帮助.. 谢谢！！！

CREATE OR REPLACE procedure SALES_BY_CLIENT (
p_p_ITEM_CODE varchar2,
p_p_DATE_from date,
p_p_DATE_TO date, 
p_p_CLIENT_CODE varchar2, cur OUT SYS_REFCURSOR
)
as
begin
 open cur for select * from 
 SL_DOC_LINES SDL
join SL_DOCUMENTS SD
on SDL.DOC_NO=SD.[NO] and SDL.DOC_YEAR=sd.[YEAR] and SDL.DOC_COUNTER_CODE=SD.COUNTER_CODE and SDL.DOC_BRANCH_CODE=SD.BRANCH_CODE
 where SDL.IT_CODE=p_p_ITEM_CODE AND (EXTRACT(MONTH FROM SD.DOC_DATE)>EXTRACT(MONTH FROM p_p_DATE_from) and EXTRACT(DAY FROM SD.DOC_DATE)<= EXTRACT(DAY FROM p_p_DATE_TO)) and SD.CLI_CODE=p_p_CLIENT_CODE;
 end;
/

标签： oracleoracle-sqldeveloperprocreserved-words