AboutSrini Nagarajan Expertise I can answer any kind of questions in ASP.NET, C#, VB.NET, SharePoint 2007, ASP, Coldfusion, Powerbuilder 7.00 / 8.00, JAVA servlets, MS SQL 2000 / MSSQL7, Sybase
Experience Contact me if you need any custom development on ASP.NET, ASP, SharePoint 2007, Coldfusion, Powerbuilder.
I have following stored procedure in oracle. which returns cursor can you please send me the asp code block to call this procedure and display the results.
-----------------------------
PACKAGE NAME: ekg_lp_gen
------------------------------
STORED PROCEDURE:
PROCEDURE get_fin_approvers(p_user_id IN VARCHAR2,
p_ccc IN VARCHAR2,
o_cursor1 OUT NOCOPY REF_CURSOR)
AS
v_ccc VARCHAR2(100);
v_grade VARCHAR2(10);
BEGIN
select hou.attribute1 into v_ccc from apps.hr_all_organization_unitS hou,
apps.pay_cost_allocation_keyflex pcaf
where pcaf.COST_ALLOCATION_KEYFLEX_ID = hou.COST_ALLOCATION_KEYFLEX_ID
and pcaf.segment2 = p_ccc;
select grade into v_grade from hrr_t_emp_master
where staffnr = p_user_id and term_date is null;
-----------------------------------------------
KINDLY GIVE ME THE ASP CODE BLOCK TO CALLING THIS STORED PROCEDURE AND GETTING THE VALUES FROM THE CURSOR. I AM USING FOLLOWING CODE WHICH IS NOT GIVING ME ANY RESULT.
---------------------------------------------
ASP CODE:
---------------------------------------------
<!--# include file="conn_open.asp" -->
<%
Dim cn, rs, cmd, oParam
Dim SQL
SQL = "{call ekg_lp_gen.get_fin_approvers(?, {resultset 0, o_cursor1})}"
set cmd = server.CreateObject ("ADODB.Command")
set rs = server.CreateObject ( "ADODB.Recordset" )
set cmd.ActiveConnection = con1
set cmd.CommandText = SQL
set cmd.CommandType = 1 'adCmdText
'Pass in 0 to retrieve all of the records
Set oParam = cmd.CreateParameter("p_user_id", adVarChar, adParamInput, "023962")
cmd.Parameters.Append oParam
Set oParam = cmd.CreateParameter("p_ccc", adVarChar, adParamInput, "5381")
cmd.Parameters.Append oParam
Set oParam = cmd.CreateParameter("o_cursor1", adVarChar, adParamReturnValue, 5000)
cmd.Parameters.Append oParam
set rs = cmd.execute
while not rs.eof and not rs.bof
Response.Write(rs(0))
wend
%>
<!--# include file = "conn_close.asp"-->
---------------------------------------------