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...
Posted to
Oracle
(Forum)
by
sthauttam
on
05-16-2007, 12:00 AM
Filed under: Oracle, OracleCommand, Parameters, Stored Proceedures, .net 2.0, c#