Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie Web page calling an oracle procedure
shall_at_uaex.edu wrote:
> 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
Wrong group -- there is a great asp group at microsoft.public.inetserver.asp.general and a series of groups under microsoft.public.inetserver.asp.* that will serve your purposes. Your questions are not Oracle questions but asp questons.
James Received on Wed Sep 13 2006 - 14:25:35 CDT