-
Posted to
Classic ASP
by
bappa001
on
09-01-2009, 9:48 AM
I have tried with the below code, but still it is not accessing the record of second cursor.
Dim rsRETax,NewConnxRETax,NewCommandxRETax
set NewConnxRETax = server.CreateObject("ADODB.Connection")
NewConnxRETax.Open ...
-
Posted to
Classic ASP
by
bappa001
on
08-29-2009, 7:41 AM
The stored procedure is returning two out curser.
the procedure is mentioned below >>>>
PROCEDURE pr_get_item_type_desc(p_user_id IN tb_xop_item_mas.user_id%TYPE DEFAULT USER,
...
-
Posted to
Classic ASP
by
bappa001
on
06-16-2009, 11:19 PM
Stored Procedure is returning the data as a out cursor
PROCEDURE PR_GET_SERVICE_YRS(p_in_ivr_plan_num VARCHAR2,
p_in_age_field VARCHAR2 DEFAULT 'BIRTH_DT',
p_out_yrsofserv OUT NOCOPY yrsofserv_cursor) IS
BEGINOPEN p_out_yrsofserv FOR
SELECT column_id,
column_nm FROM tb_xop_re_dt_setup
WHERE ivr_plan_num = p_in_ivr_plan_numAND ...
-
Posted to
Classic ASP
by
bappa001
on
06-16-2009, 5:56 AM
I have a stored procedure with output type as cursor.I want to store the output in a record set, to load a dropdown list.
if anyone can give me some sample code, or some idea about implementation, it will be very helpful.
Thanks in advance.
-
Posted to
Classic ASP
by
bappa001
on
06-15-2009, 5:37 AM
No i am not getting any error msg.while executing the stored procedure on db itself, it is working, but It is not getting ececuted from the ASP code.
I have taken trace to see that if procedure is getting ececuted or not, but not getting any thing.it seems to be NewCommandx1.Execute is not working.
-
Posted to
Classic ASP
by
bappa001
on
06-15-2009, 3:21 AM
I have the following code ,but data is not getting updated to database.please help
set NewConnx = server.CreateObject("ADODB.Connection")
NewConnx.Open Session("MyConnection")
set NewCommandx1 = server.CreateObject ("ADODB.Command")
set NewCommandx1.ActiveConnection = ...