Hello! I need to create table in oracle database by using connect to oracle from SAS EG. Proc sql; connect to oracle as ora(PATH=ORAPATH USER=ORAUSER PASSWORD="ORAPASS"); execute( CREATE TABLE SMS_INFO_CONTACT_HIST (App_id DECIMAL(16,0), Reg_id NUMBER(3), MSISDN VARCHAR(11), UCP_CONTACT_ID NUMBER(22,0), COALESCE_CONTACT_DTTM TIMESTAMP(0), camp_name VARCHAR(100), sender_name VARCHAR(50), contact_text VARCHAR(1024)); create unique index UCP_CONTACT_ID on SMS_INFO_CONTACT_HIST (UCP_CONTACT_ID); ) by ora; disconnect from ora; quit; But an error occurs. SAS EG log: ERROR: ORACLE execute error: ORA-00922: missing or invalid option. Code works in PL SQL: CREATE TABLE SMS_INFO_CONTACT_HIST (App_id DECIMAL(16,0), Reg_id NUMBER(3), MSISDN VARCHAR(11), UCP_CONTACT_ID NUMBER(22,0), COALESCE_CONTACT_DTTM TIMESTAMP(0), camp_name VARCHAR(100), sender_name VARCHAR(50), contact_text VARCHAR(1024)); create unique index UCP_CONTACT_ID on SMS_INFO_CONTACT_HIST (UCP_CONTACT_ID); Can't understand, whats wrong. Maybe someone came across and can explain? I would really appreciate your help. Thank You
... View more