Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> calling PL/SQL from ASP
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
![]() |
![]() |