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

Home -> Community -> Usenet -> c.d.o.tools -> calling PL/SQL from ASP

calling PL/SQL from ASP

From: SP <spant1_at_aol.com>
Date: 2000/06/23
Message-ID: <KjO45.144$0x.4623@nuq-read.news.verio.net>#1/1

I had this code in ASP calling a SQL server stored procedure sp_onsale . sqlprod = "execute sp_onsale -1," & Cint(CUSTSTRING_departmentID) & ",'" & CUSTSTRING_src & "'"
Now I've written sp_onsale in Oracle using ref cursor. I tested the function typing the following lines in SQL plus and it worked. variable c refcursor
exec :c := sp_onsale (-1,20')
print c
The problen now is how do I call it from ASP? Any suggestions?

SP Received on Fri Jun 23 2000 - 00:00:00 CDT

Original text of this message

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