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 -> Re: newbie Web page calling an oracle procedure

Re: newbie Web page calling an oracle procedure

From: ManChild <starritt_at_gmail.com>
Date: 13 Sep 2006 12:25:35 -0700
Message-ID: <1158175535.480357.110910@i42g2000cwa.googlegroups.com>

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

Original text of this message

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