hi, i am working with c#.net application with oracle database. i am facing with 2 issues.

1. i am using oracle stored procedures. i want to store the record entering date and time in oracle single field. so i am using timestamp datatype in oracle. but i am not able to use timestampe datatype in oracle stored procedure .

for example
table name : empmaster
fields : eid numeric, ename varchar(10) , enter_dt timestamp
i want to insert the records into this 3 fiedls using oracle stored procedure.

2. i would like to create the separate database in oracle like sql server to maintain the tables separate database . is it possibe ?

 thank you sir.

These sound like Oracle questions to me. You would be better asking them on an Oracle forum, and not on a C# forum.

/- Sam Judson : Wrox Technical Editor -/