Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Question: Oracle 7.3, Visual InterDev, Stored Proceedure
I have all the components that are needed and have check each of the installations
and functions and everything seems set up fine.
Tech used.
IIS 4.0 on NT SP4, Active Server Pages (ASP), Oracle 7.3.3.0.0, Required Support Files 7.3.3.5.2, SQL Net 2.3.3.0.4, and ADO 2.0.
Currently I have tried using both VI 1.0 and VI 6.0 to run the stored proceedures. I can get then to run on VI 6.0 by selecting the stored proceedure, right clicking and selecting run and giving it values. But if I try to run the stored proceedure from a asp page I get errors. (sorry I don't have the syntax right now.) But they are like "The application is using a value of the wrong type for the current operation. " and such.
They were all in one package but we created the same individually as well, because there were no global variables required.
Is anyone doing VI/ASP development and using stored proceedures with success. Please post samples.
Or anyone creating VB components, I could create a webobject in vb that does the stored proceedure and expose the values. But I'd like to just do the connection with vbscript.
The returned values for the stored proceedures are anything from a single true/false value to a recordset. Thanks for any help.
Please email the reply to me. I need this one as fast as I can get it.
Thanks more than you know.
Craig G.
gjerdingen_at_usinternet.com Received on Thu Nov 19 1998 - 13:39:10 CST