|
 URGENT HELP NEEDED
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.
APPRECIATE YOUR HELP IN ADVANCE
THANKS,
AZEEM QAISER
|
|
|
|
|
I sat down and started the application when I went to open a file in the projects folder... It says its gone renamed It tells me to expand the project node for more info... HELP weird stuff going on.
|
|
|
|
|
Are you new to web development?
If so, I'd suggest buying (or finding a friend that has -- i cannot suggest pirating in good conscience, but it's there) a good book on it.
Specifically, Beginning ASP.NET 2005 in C#. (or VB.NET if you prefer) Published by Apress. Between $30-40US.
http://www.amazon.com/Beginning-ASP-NET-2-0-2005-Professional/dp/1590595726/ref=sr_1_4/105-1894697-3759602?ie=UTF8&s=books&qid=1190778126&sr=8-4
In fact, I still have my series of Apress books I keep for references. They come in handy.
|
|
|
|
|
Hi everyone!
I have a html page with an IFrame; and the following code:
var doc = document.getElementById("iframe_id").contentDocument;
doc.body.innerHTML = htmlCode;
This code is run in body's onload handler. 'htmlCode' contains some (very simple) html (it is a string, of course).
I was able to test this code only in Safari 1.3 (Mac), and it didn't work 
BUT: I need to test it in a Safari 2.0.4. Unfortunatelly, I don't have access to it. Anyone (with Mac) can tell me if it will work?
And why the above code didn't work with Safari 1.3? Is it possible to fix it?
Thank you very much in advance!
P.S. I understand it is a MS-centric forum, but... I do hope.
-------------------------
Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).
|
|
|
|
|
You might have better luck with writing the entire page into the iframe. Example:
var doc = document.getElementById("iframe_id").contentDocument;
doc.open();
doc.write('<html><head><title></title></head><body>'+htmlCode+'</body></html>');
doc.close();
---
single minded; short sighted; long gone;
|
|
|
|
|
Ok, this variant does work  But what to do with the original code? Does it work in the Safari 2?...
Thanks anyway.
-------------------------
Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).
|
|
|
|
|
Dmitry Khudorozhkov wrote: But what to do with the original code? Does it work in the Safari 2?...
I don't know. I don't have a mac.
---
single minded; short sighted; long gone;
|
|
|
|
|
Dmitry Khudorozhkov wrote: But what to do with the original code? Does it work in the Safari 2?...
That code does work on Safari for Windows, although it's a little bit different in size and exact location.
Eriawan
|
|
|
|
|
I wrote a Windows Forms application in Visual Basic 2005.
What would be involved in converting it to run as an internet web application?
|
|
|
|
|
A full rewrite.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
This Visual Basic 2005 app is basically a wizard that starts out with a background image. Then the user selects a number of images to overlay it producing a final image that is saved for later retrieval, and can be printed or emailed.
The 'other' images are .png files with transparent backgrounds.
Can the vb.net code be installed on the web server and executed from a browser as an internet app or does it have to be rewritten and, if so, in what language?
|
|
|
|
|
It depends how you've written the code, but it may well need totally re-written, at least the front end will.
You'll be going from a nice state-ful environment to a totally stateless one. Sounds like you might also need some fun javascript for interacting with your overlays.
|
|
|
|
|
|
 hai
i am an asp programmer.
i have two combo boxes optone and opttwo.
i have loaded values for optone from database
selected
<%
sqlPRO = "Select field1 From tablename"
set rs= conn.Execute(sqlPRO)
i=1
do while Not rs.EOF
%>
<%=rs("field1")%>
<%
i=i+1
rs.MoveNext
loop
rs.Close
%>
now i want to load a value for the second combobox opttwo
it's dependant on the first combobox optone
function setOptions(chosen)
{
var selbox = document.frm.opttwo;
selbox.options.length = 0;
selbox.options[selbox.options.length] = new Option('Select','oneone');
<%
strSQLQry = "Select field1 From tablename where ID='" & chosen & "'"
rs.Open strSQLQry, conn
rs.MoveFirst
While Not rs.EOF
%>
valFromList = "<%=rs("field1")%>";
selbox.options[selbox.options.length] = new Option(valFromList,'oneone');
<%
rs.MoveNext
Wend
rs.Close
%>
}
this code shows an error.i can't get the javascript variable into asp.
if anyone known please help me
Ganesh Mohan
|
|
|
|
|
The javascript variable is in memory in the Browser Instance. The ASP variable is in memory in the Web Server instance. Two different processes.
Values in the Browser are transfered to the Server by sending a POST or GET request to the Server. Values in the Server are sent to the Browser in the Response Stream of the request.
|
|
|
|
|
Don't cross post.
I answered this in the ASP.NET forum.
---
single minded; short sighted; long gone;
|
|
|
|
|
Actually when i run my application in firefox and in Internet Explorer my pages are not appeared similar. So I want to know how to auto adjust the pages so that they appeared similar in any browser.
|
|
|
|
|
You basically have to play with your CSS until you find styles that render the same in both.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
There are some tags which are supported by IE but not by FireFoz and vise versa.
Sometimes you need to use HTML tags according to browser type. Browser compatibility may prove to be a very big issue if you dont pay attention from scratch.
So just keep your design simple and follow basic HTML rules and test your design on other browsers like Opera and Safari while developing your site.
Best Of Luck
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
i am have developed a project on jsp and end user script is javascript.
then i have uploaded the same in my intranet site.
It woked for IE, netscape and firefox.
But it did not show up in the safari browser of the mac.
how do i go about solving the issue
is that becoz of the compatibility?
|
|
|
|
|
Yes, it may be a compatibility issue. For some JS events, Safari behaves differently than IE and Mozilla.
Like in IE and Firefox, onFocus event is treated same as OnClick event. But safari donot.
Sometimes onBlur also creates some problems in Safari.
You have to debug your script to find the code which is not working as expected.
Best Of Luck
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
Hi,
I have encountered problem when saving string value with double quote in it. When I attempt to save it into the mssql database an error message will display.
Example:
Textbox1.text content is - Round Bar 1/2" dia.
Dim sItemID = "00001"
Dim sDescription = Textbox1.text
Dim ItemCmd = New SQLCommand("Insert into Item " _
& "(" _
& "ItemID, " _
& "Description " _
& ")" _
& "Values " _
& "(" _
& "'" & sItemID & "'," _
& "'" & sDescription & "'" _
& ")"
During saving the error will occur:
String or binary data would be truncated.
The statement has been terminated.
The error will be fixed if I add the "SET ANSI_WARNINGS OFF" in my sql statement, but this is not the ultimate solution because the double apostrophe or quotation will be removed by the system itself when saving.
And, if I removed the "SET ANSI_WARNINGS OFF" this error will display:
Unlclosed quotation mark
Is there a way to resolve it?
I have been solving this for two days already and no luck yet.
Thanks Guys
hifiger2004
|
|
|
|
|
A quotation mark (") is not a problem in an SQL string. Are you sure that it's not two apostrophes (')?
You have to escape apostrophes in string values by doubling them if you put the values directly in the SQL query. It's better to use parameters instead of putting the values directly in the query.
---
single minded; short sighted; long gone;
|
|
|
|
|
You're right guffa, I changed my way of coding instead of putting it directly in the query, I used the sqlparameter approach and it works fine now.
Thank you
hifiger2004
|
|
|
|
|
Try putting the following text into your textbox1 and then think about parameterising this query:
'); delete from item; --
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
