Hi!

I have two tables Address(address_id, street) and Employee(emp_id,address_id,name).  // address_id in Employee table is foreign key

Here is my stored procedure.

CREATE OR REPLACE PROCEDURE address_proc
       (street in varchar2,
        name in varchar2)
 is
 BEGIN
     INSERT INTO address
         VALUES (address_id_seq.nextval,street);
     INSERT INTO employee
         VALUES (emp_id_seq.nextval,address_id_seq.currval,name);
     commit;
 END;

Now, how can I insert data from  a webpage that has input text field for street and name?  I mean to say that a webpage has two input fields street and name. Now I have to save those two fields in separate tables with using the single stored procedure as given above. I am using Oracle 9i and ASP.NET 2.0

Any suggestions are highly appreciated.

You'd just create an OracleDbConnection that points to your Oracle server, you'd create an OracleDbCommand that points to your sproc and is of the StoredProceudre CommandType, you add the parameters (named and in the correct order) to your Command and you call ExecuteNonQuery.

Which part are you having trouble with?

Hi Stiletto,

Thanks for suggestion,

I have found that there was a problem in Stored Procedure. Could you please suggest me how to wrtie stored procedure for the mention problem?

I would appreciate your help.

Thank you,

What's the error the stored procedure is giving? 

The only thing that looks like it sould be an issue to me is the reference to currValue.  If that's it, then select the nextValue into a local variable and them pass it explicitly to both the tables.

Hi stiletto,

Thanks, I have solved the problem. Hope you will guide me in near future.

 Thanks,