newbie Web page calling an oracle procedure

How do I take a web (ASP) page and call a stored procedure or a procedure and pass it my variable of myuserid="12345" and myqty=1 ???

I'm reading Oracle 9i database and trying to call it from Active Server Pages (ASP)

a snippet of the procedure:

SELECT Qty INTO Origqty
FROM PUBLICATIONS
WHERE ( item LIKE 'abcde' AND myid LIKE myuserid ) FOR UPDATE of QTY;
/*** do some checking before UPDATE *****/

Update PUBLICATIONS SET Qty=(OrigQty-myQty) WHERE ( item LIKE 'abcde' );

COMMIT; TIA
Steve Received on Wed Sep 13 2006 - 14:07:06 CDT