.net with oracle stored procedure
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 .
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.