Issue with create global temporary table

[Healthc12]

Error starting at line 1 in command:
create global temporary table inpatient_census

(ic_servicing_type vchar(1) null,
ic_member_county vchar2(50) null,
ic_icd9 vchar2(11) null),
ic_primary_diagnsois vchar2(50) null,
ic_member_dob date,
ic_member_name vchar2(64) null,
ic_member_id vchar2(80) null,
ic_last_note date,
ic_date_admitted date,
ic_auth_days number(5,0),
ic_tcm_uid number(10,0),
ic_servicing_facility number(10,0))
on commit delete rows
Error at Command Line:3 Column:24
Error report:
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:

Thanks for your assistance in advance!

 

[LKBrwnDBA]

What is "vchar2"? a new data type?




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Also, your code has an extra right paren on the line defining the table column, "ic_icd9". Once you address that issue and the "vchar" and "vchar2" corrections, your code should work fine:

create global temporary table inpatient_census
(ic_servicing_type varchar2(1) null,
 ic_member_county  varchar2(50) null,
 ic_icd9           varchar2(11) null,
 ic_primary_diagnsois varchar2(50) null,
 ic_member_dob     date,
 ic_member_name    varchar2(64) null,
 ic_member_id      varchar2(80)  null,
 ic_last_note      date,
 ic_date_admitted  date,
 ic_auth_days      number(5,0),
 ic_tcm_uid        number(10,0),
 ic_servicing_facility number(10,0))
 on commit delete rows

Table created.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[Healthc12]

Thanks