Forum Stats

  • 3,874,197 Users
  • 2,266,682 Discussions
  • 7,911,767 Comments

Discussions

using sqlplus yields an error: ORA-00923: FROM keyword not found where expected

ALEXCOL
ALEXCOL Member Posts: 7 Green Ribbon

Good evening, I nred your help please, Im Just started to learn sqlcode, and for my learnings sake Im trying to get the values for each column, so these variables can be passed to unix,

Im using sqlplus client and dont know if this is the problem, bcz in the select command when i select less than 3 fields works OK, but adding more columns yields an error:

ORA-00923: FROM keyword not found where expected


This is the query:

SET FEEDBACK OFF verify off lines 50 pages 0

 var cycle varchar2(99)

exec :cycle := '${billcycle}';


select COD_CLIENTE||','||NUM_ABONADO||','||COD_CICLFACT||','||COD_CARG||','||SUBSTR(COD_CICLFACT,1,1) CICLO||','||SUBSTR(COD_CLIENTE,8,8) LD

from tablex

where COD_CICLFACT = :cycle and dur_real > 700000000;

Even though I break up my query to multiple lines it yields the same error

This is a Record example:

COD_CLIENTE NUM_ABONADO COD_CICLFACT  

  43607574  99353513    90122    9945

The output shold be:

43607574,99353513,90122,9945,9


I appreciate your help in advanced

Answers

  • User_H3J7U
    User_H3J7U Member Posts: 1,062 Gold Trophy

    Sqlplus marks the error position with *. Use the exact sqlplus output and code formatting to show this.

    SQL> var cycle varchar2(99)
    SQL> exec :cycle := '${billcycle}';
    
    PL/SQL procedure successfully completed.
    
    SQL> select COD_CLIENTE||','||NUM_ABONADO||','||COD_CICLFACT||','||COD_CARG||','||SUBSTR(COD_CICLFACT,1,1) CICLO||','||SUBSTR(COD_CLIENTE,8,8) LD
      2  from tablex
      3  where COD_CICLFACT = :cycle and dur_real > 700000000;
    select COD_CLIENTE||','||NUM_ABONADO||','||COD_CICLFACT||','||COD_CARG||','||SUBSTR(COD_CICLFACT,1,1) CICLO||','||SUBSTR(COD_CLIENTE,8,8) LD
                                                                                                               *
    ERROR at line 1:
    ORA-00923: FROM keyword not found where expected