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
>

Have you looked on Google to see if there are code snippets you can peruse to give yourself an idea?

http://www.asp101.com/articles/wrox/asp30/26100903.asp

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown