select query

[dodda]

hello

i am writing a simple select query from oracle database by using oracle enterprise stage.

select null as DATA from DB_SHP_DT

i defined DATA as column name and i want null values in the column.

I am extracting the data from database and writing it to dataset.

when i tried to execute its getting aborted. what is the sql type i need to define for DATA column.

Thanks

[keshav0307]

varchar.
what is the error ??

[ray.wurlod]

Is DATA a reserved word in your database? Is "DATA" a nullable column in this table?