Getting Data In

DB Connect invalid character error

nnesje
Loves-to-Learn

Receiving the following error: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

However, no character is highlighted in the Data Lab SQL editor for the following query:

select LI.BBY_ACTIVATION_LINK_SEQ ,li.bby_activation_line_seq , li.bby_pos_sale_seq, li.bby_plan_match_flg, pl.pos4partkey, pl.line_item_type POS_LINE_ITEM_TYPE,pl.hardware_sku POS_HARDWARE_SKU,pl.hardware_esn POS_HARDARE_ESN,pl.void_status POS_VOID_STATUS,pl.activation_phone_nbr POS_PHONE_NUMBER,pl.bbym_bskt_id POS_BAKT_ID, pl.bby_plan_sku POS_PLAN_SKU,al.hardware_type ACTIVATION_LINE_TYPE, al.hardware_esn ACTIVATION_HARDWARE_ESN,al.activation_phone_nbr ACTIVATION_PHNE_NUMBER, al.activation_type,al.tender_status ACTIVATION_TENDER_TYPE, al.actv_mthd, al.created_on ACTIVATION_CREATED_ON, al.amended_on ACTIVATION_AMENDED_ON,pl.created_on POS_LINE_CREATED_ON,pl.amended_on POS_LINE_CREATED_ON,li.created_on LINK_CREATED_ON from bst_bbym_sch01.BBY_POS_BEAST_ACTIVATION_LINK LI,bst_bbym_sch01.BBY_ACTIVATION_LINE AL,bst_bbym_sch01.BBY_POS_SALE_LINE PL where LI.BBY_POS_SALE_SEQ = PL.BBY_POS_SALE_SEQ and LI.BBY_ACTIVATION_LINE_SEQ = AL.BBY_ACTIVATION_LINE_SEQ and li.transaction_line_no = pl.transaction_line_no AND LI.created_on >= sysdate – 1

Is there something obvious I'm missing?

Labels (1)
0 Karma

saravanan90
Contributor

This seems to be sql syntax error, changing the below is getting validated in the below url.

LI.created_on >= sysdate -1

https://www.eversql.com/sql-syntax-check-validator/

 

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.