Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> newbie Web page calling an oracle procedure

newbie Web page calling an oracle procedure

From: <shall_at_uaex.edu>
Date: 13 Sep 2006 12:07:06 -0700
Message-ID: <1158174426.628715.285030@h48g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US