Click here to Skip to main content
15,915,501 members
Home / Discussions / Web Development
   

Web Development

 
QuestionHow the FILEUPLOAD to prevent from posting back? Pin
hifiger200423-Sep-07 7:23
hifiger200423-Sep-07 7:23 
AnswerRe: How the FILEUPLOAD to prevent from posting back? Pin
Guffa23-Sep-07 8:57
Guffa23-Sep-07 8:57 
GeneralRe: How the FILEUPLOAD to prevent from posting back? Pin
hifiger200423-Sep-07 12:16
hifiger200423-Sep-07 12:16 
GeneralRe: How the FILEUPLOAD to prevent from posting back? Pin
Christian Graus23-Sep-07 12:42
protectorChristian Graus23-Sep-07 12:42 
AnswerRe: How the FILEUPLOAD to prevent from posting back? Pin
hifiger200423-Sep-07 17:20
hifiger200423-Sep-07 17:20 
GeneralRe: How the FILEUPLOAD to prevent from posting back? Pin
Christian Graus23-Sep-07 19:17
protectorChristian Graus23-Sep-07 19:17 
GeneralRe: How the FILEUPLOAD to prevent from posting back? Pin
Malcolm Smart27-Sep-07 2:15
Malcolm Smart27-Sep-07 2:15 
QuestionURGENT: Please Help - ASP Error Pin
Azi Qaiser23-Sep-07 2:10
Azi Qaiser23-Sep-07 2:10 
Confused | :confused: URGENT HELP NEEDED Confused | :confused:
ERROR1: (if provider is msdaora)
Provider (0x80040E55)
Column does not exist.

ERROR 2: (if provider is OraOLEDB.oracle)
OraOLEDB (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Hi,
i am getting above mentioned errors when i am trying to access an stored procedure in oracle 9i from an asp page. The stored procedure accepts two input variables and returns a ref cursor with result. SP is working fine if i test it at the backend.

CODE:
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;

xx_egpo_sro_req_pkg.get_approvers(p_user_id => p_user_id,
p_ccc => v_ccc,
p_grade => substr(v_grade,4),
o_cursor => o_cursor1 );



END GET_FIN_APPROVERS;
----------------------------------------------------------------------------------------
ASP CODE:
----------------------------------------------------------------------------------------

<%
db_CFRS = "Provider=msdaora; Data Source=erpudev; User ID=apps; Password=devapps"
SET Con = Server.CreateObject("ADODB.Connection")
Con.Open db_CFRS

Set cmdCfrsEmail= Server.CreateObject("ADODB.Command")
With cmdCfrsEmail
Set .ActiveConnection = Con
.CommandType = adCmdText
Set paramUser_Id = .CreateParameter("p_user_id", adVarChar, adParamInput, 100, "p_ccc")
.Parameters.Append paramUser_Id
Set paramCCC = .CreateParameter("p_ccc", adVarChar, adParamInput, 10, "5381")
.Parameters.Append paramCCC
SET paramOutput = .CreateParameter("o_cursor1",adVarChar,adParamOutput,5000)
.Parameters.Append paramOutput

' Resultset will fetch up to 100 actions currently. Increase if necessary
.CommandText = "{call xx_egpo_sro_req_pkg.get_fin_approvers(?,?,{resultset 100, o_cursor1})}"

'Response.Write .CommandText
Set rsCFRS =.Execute()
End With
%>
----------------------------------------------------------------------------------------
PLEASE HELP URGENTLY AS I AM NEARING DEADLINE AND THIS IS THE CHANGE REQUESTED URGENTLY.

Confused | :confused: APPRECIATE YOUR HELP IN ADVANCE Confused | :confused:

THANKS,
AZEEM QAISER
QuestionVisual Web 2005 Express HELP Pin
Rocky Mt. High22-Sep-07 20:27
Rocky Mt. High22-Sep-07 20:27 
AnswerRe: Visual Web 2005 Express HELP Pin
Jpuckett25-Sep-07 17:43
Jpuckett25-Sep-07 17:43 
QuestionSafari (Mac) + innerHTML Pin
Dmitry Khudorozhkov22-Sep-07 10:16
Dmitry Khudorozhkov22-Sep-07 10:16 
AnswerRe: Safari (Mac) + innerHTML Pin
Guffa22-Sep-07 10:50
Guffa22-Sep-07 10:50 
GeneralRe: Safari (Mac) + innerHTML Pin
Dmitry Khudorozhkov22-Sep-07 10:52
Dmitry Khudorozhkov22-Sep-07 10:52 
GeneralRe: Safari (Mac) + innerHTML Pin
Guffa22-Sep-07 14:43
Guffa22-Sep-07 14:43 
AnswerRe: Safari (Mac) + innerHTML Pin
kuyak200024-Sep-07 19:29
kuyak200024-Sep-07 19:29 
QuestionConvert a VB.Net app to a web app? Pin
furjaw21-Sep-07 17:58
furjaw21-Sep-07 17:58 
AnswerRe: Convert a VB.Net app to a web app? Pin
Christian Graus21-Sep-07 18:32
protectorChristian Graus21-Sep-07 18:32 
QuestionRe: Convert a VB.Net app to a web app? Pin
furjaw22-Sep-07 8:54
furjaw22-Sep-07 8:54 
AnswerRe: Convert a VB.Net app to a web app? Pin
Paddy Boyd24-Sep-07 4:33
Paddy Boyd24-Sep-07 4:33 
GeneralThe Need For Speed Pin
Bassam Abdul-Baki21-Sep-07 7:18
professionalBassam Abdul-Baki21-Sep-07 7:18 
Questionhow to pass a javascript variable into asp variable? Pin
ganeshMohan21-Sep-07 2:35
ganeshMohan21-Sep-07 2:35 
AnswerRe: how to pass a javascript variable into asp variable? Pin
led mike21-Sep-07 4:38
led mike21-Sep-07 4:38 
GeneralRe: how to pass a javascript variable into asp variable? Pin
Guffa22-Sep-07 7:55
Guffa22-Sep-07 7:55 
Questionhow to auto adjust pages Pin
harryforum20-Sep-07 23:18
harryforum20-Sep-07 23:18 
AnswerRe: how to auto adjust pages Pin
Christian Graus21-Sep-07 0:35
protectorChristian Graus21-Sep-07 0:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.