ORA-00933 SQL command not closed properly

Asked

Viewed 204 times

0

Hello, good afternoon

I am trying to run the following select on TOAD, but the error is occurring: ORA-00933 SQL command not closed properly

SELECT ROWID,
       ECM_WF_PROC.IDWF_PROC, 
       ECM_WF_PROC.PROCESSO, 
       TD_DADOS_ETAPAS.SITUACAO, 
       TD_DADOS_ETAPAS.DATAINICIAL, 
       TD_DADOS_ETAPAS.DATAFINAL, 
       TD_DADOS_ETAPAS.DATAPREVISTA
  FROM ECM_WF_PROC AS ECM_WF_PROC_ETAPAS,
  LATERAL(SELECT ECM_WF_PROC_ETAPAS.SITUACAO AS SITUACAO, 
                 ECM_WF_PROC_ETAPAS.DATAINICIAL AS DATAINICIAL, 
                 ECM_WF_PROC_ETAPAS.DATAFINAL AS DATAFINAL, 
                 ECM_WF_PROC_ETAPAS.DATAPREVISTA AS DATAPREVISTA
            FROM ECM_WF_PROC_ETAPAS AS ECM_WF_PROC_ETAPAS
           WHERE ECM_WF_PROC_ETAPAS.IDEMPRESA = ECM_WF_PROC.IDEMPRESA AND
                 ECM_WF_PROC_ETAPAS.IDWF_PROC = ECM_WF_PROC.IDWF_PROC) AS TD_DADOS_ETAPAS
WHERE ECM_WF_PROC.PROCESSO = '177920'

Could you help me fix it?

sql oracle select

  • is running with F5? ever tried to put a ; at the end of the command?

  • I am, the same error happens running with shift+F9 or F5.

  • with is using the side Join ai and only has fields of the table "ECM_WF_PROC_ETAPAS" in the subquery, can remove the alias "TD_DADOS_ETAPAS" and in the main query use "ECM_WF_PROC_ETAPAS" instead to make a test?

  • Opa, thanks for the attention Ricardo, I was doing a research and the ROWID I must which table should be considered ROW ID. This way it was only added in select ECM_WF_PROC_ETAPAS.ROWID

No answers

Browser other questions tagged sql oracle select

You are not signed in. Login or sign up in order to post.