|
 |
asp_databases thread: Using ASP to execute Oracle Stored Procedures
Message #1 by Rowenap@w... on Thu, 28 Sep 2000 12:56:53 +0100
|
|
-----Original Message-----
From: chen yew wong [mailto:Chen.Yew.Wong@w...]
Sent: 28 September 2000 19:01
To: support@w...
Subject: Using ASP to execute Stored Procedures
Importance: High
Dear Sir/Madam,
Can you please shed some light as to how I can change the following
examples obtained from the "Beginning ASP Databases" to execute Oracle
stored procedures.
To call a procedure
page 551 - objCmd.CommandText = "{CALL qparmBoats ('" & CStr(strboat) &
"')}"
To call a procedure that returns a value
page 583 - objCmd.CommandText = "{? = CALL
dbo.up_select_count_of_people}"
Thank you and best regards.
Yew Wong
Message #2 by "Puskar Adhikari" <puskar@h...> on Fri, 29 Sep 2000 11:49:06 EDT
|
|
Hello,
i also have similar problem
i have created stored procedure with oracle and i was not
sure how i would call it using ASP
i am trying to pass three paramaters like ID, name and message
using oracle and the name of my stored procedure is called
addnewdata.
thank you very much
Puskar :)
>2000.09.28-13.13.04--puskar#hotmail.com@p...>
>
>-----Original Message-----
>From: chen yew wong [mailto:Chen.Yew.Wong@w...]
>Sent: 28 September 2000 19:01
>To: support@w...
>Subject: Using ASP to execute Stored Procedures
>Importance: High
>
>
>Dear Sir/Madam,
> Can you please shed some light as to how I can change the following
>examples obtained from the "Beginning ASP Databases" to execute Oracle
>stored procedures.
>
> To call a procedure
> page 551 - objCmd.CommandText = "{CALL qparmBoats ('" & CStr(strboat) &
>"')}"
>
> To call a procedure that returns a value
> page 583 - objCmd.CommandText = "{? = CALL
>dbo.up_select_count_of_people}"
>
>
>Thank you and best regards.
>
>
>Yew Wong
>
|
|
|
View Cart
