OraFAQ Forum: General » asp -> stored procedures not using adobdb.command?

Home » Other » General » asp -> stored procedures not using adobdb.command?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

asp -> stored procedures not using adobdb.command? [message #224812]

Thu, 15 March 2007 10:20

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

joy_division
Messages: 4963
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.

Report message to a moderator

Re: asp -> stored procedures not using adobdb.command? [message #224975 is a reply to message #224812]

Fri, 16 March 2007 04:09

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

Report message to a moderator

Re: asp -> stored procedures not using adobdb.command? [message #226557 is a reply to message #224975]

Sun, 25 March 2007 01:55

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.

Report message to a moderator

Previous Topic:	get tables views???
Next Topic:	difference between replication and dataguard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 20:02:37 CDT 2024