Home » Other » General » asp -> stored procedures not using adobdb.command?
asp -> stored procedures not using adobdb.command? [message #224812] Thu, 15 March 2007 10:20 Go to next message
cefb
Messages: 56
Registered: March 2007
Member
hi!!!!

Is there any way of calling a procedure that as a cursor as a out parameter without using adodb.command in asp?



Thanks

[Updated on: Thu, 15 March 2007 10:24]

Report message to a moderator

Re: asp -> stored procedures not using adobdb.command? [message #224842 is a reply to message #224812] Thu, 15 March 2007 12:37 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Please update this message with the missing letters because I can't understand what it means.
Re: asp -> stored procedures not using adobdb.command? [message #224975 is a reply to message #224812] Fri, 16 March 2007 04:09 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
if i have

create or replace procedure (my_cursor out sys_refcursor)
...
...
...

in my asp page i have

dbconn=Server.CreateObject("adodb.connection")
then i have
objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = objConn
objCommand.CommandType = adCmdStoredProc
objCommand.CommandText = "getemp"
objCommand.Parameters.Append objCommand.CreateParameter("param1", adInteger, adParamInput, 10, 0)

rs = Server.CreateObject("ADODB.Recordset")
rs = objCommand.Execute


My question is if i can execute and get the cursor data using only adodb.connection and/or adodb.recordset


Thanks





Re: asp -> stored procedures not using adobdb.command? [message #226557 is a reply to message #224975] Sun, 25 March 2007 01:55 Go to previous message
kiran
Messages: 503
Registered: July 2000
Senior Member
cefb wrote on Fri, 16 March 2007 04:09
if i have
My question is if i can execute and get the cursor data using only adodb.connection and/or adodb.recordset


Thanks




Not clear on your question,can you be more elaborate.

-Kiran.
Previous Topic: get tables views???
Next Topic: difference between replication and dataguard
Goto Forum:
  


Current Time: Fri Dec 02 18:34:14 CST 2016

Total time taken to generate the page: 0.20612 seconds