ODP.NET

Hi!

How can I call this stored procedure:

(create script)

create or replace procedure insert_date (p1 in varchar2, p2 in number, p3 in varchar2)
as
begin
insert into XXX.leg_instance
select p1, p2, p3 ,trunc(sysdate, 'year')+t.n
from XXX.flight_legs, (select rownum -1 n from dual
connect by level <= 366) t
where XXX.flight_legs.flight_no = p2
and XXX.flight_legs.frequency like '%'||to_char(trunc(sysdate, 'year')+t.n, 'd', 'nls_date_language=AMERICAN')||'%';
end;

from an ASP.NET (C#) web page?

This sp inserts:

Carrier, flight number, departure time and flight date into the leg instance table:

(create script)

CREATE TABLE "XXX"."LEG_INSTANCE"
( "CARRIER_CODE" VARCHAR2(2 BYTE) NOT NULL ENABLE,
"FLIGHT_NO" NUMBER(4,0) NOT NULL ENABLE,
"DEP_TIME" VARCHAR2(6 BYTE) NOT NULL ENABLE,
"FLIGHT_DATE" DATE NOT NULL ENABLE,
CONSTRAINT "LEG_INSTANCE_PK" PRIMARY KEY ("CARRIER_CODE", "FLIGHT_NO", "DEP_TIME", "FLIGHT_DATE");

Any suggestions greatly appreciated.

Thanks!