|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
How to call and use an Oracle stored procedure on ASP? |
|
From: |
Glenski |
|
Date: |
5/9/2000 5:35:35 AM |
|
IP: |
198.80.192.152 |
Im having a problem calling an SP from an Oracle database. SQL Server seems so easy with regards to SP but how do you code an Oracle SP to give you a result set of a table. Heres my subroutine in ASP below;
SUB RetrieveRows()
THIS PORTION GIVES YOU ERROR WITH REGARDS TO THE SP
Cmd.CommandText = "{call X_SP_IOS_RETRIEVE_JOBS}"
SET rsGrid = Cmd.Execute
BUT WHEN I USE THIS EMBEDDED SQL STATEMENT IT RUS FINE
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConnect
Set rsGrid = conn.Execute("SELECT * FROM PERSONAL_TABLE")
END SUB
I would appreciate it if you can email me the solution.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
