Oracle prepare error

[sanjay1]

Hi Team,

I am trying to pull some data from oracle database, but I am getting the below error.

ERROR: ORACLE prepare error: ORA-00933: SQL command not properly ended. SQL statement: select Number, DATE_SEND from L_fact
where DATE_SEND >='20180822'd and DATE_SEND <='20180828'd.

proc sql feedback;
connect to oracle (user=&user password="&pass." path="@BOCP" buffsize=5000);
create table Sample as
select * from connection to oracle
(
select
Number,
DATE_SEND 

from L_fact

where

DATE_SEND >='20180822'd and DATE_SEND <='20180828'd );

quit;

Thanks & Regrads,

Sanjay

[Kurt_Bremser]

Look how Oracle date literals have to be written. Do a google search for "oracle sql date literal" and follow the first link.

BTW your date literals are invalid in SAS, too.