Oracle prepare error

sanjay1 — Wed, 29 Aug 2018 11:09:54 GMT

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

Re: Oracle prepare error

Kurt_Bremser — Wed, 29 Aug 2018 11:19:06 GMT

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.

topic Oracle prepare error in SAS Programming

Oracle prepare error

Re: Oracle prepare error