i want to send mails internally and externally for eg. i want to send mail to my boss in the company and also to the customer which doesnt belong to our domain.
[URL]
and also i want to attach an excel file which is stored in my computer. so how am i going to access that file through the same procedure and then attach the file and send it to both internal as well as external email ids.
I would like to know if there is a way to call Oracle stored procedure from inside code?
View 2 RepliesThis is surareddy. i nead some small clarification in the "Stored Procedure"
how to convert the oracle Stored Procedure to sqlserver2005/2008 Stored Procedure.
right now i am enhancing the project that project already developed the oracle Stored Procedure. now our company is using sqlserver 2005/2008.
how to convert the Oracle Stored Procedure to sqlserver 2005 Stored Procedure
[Code]....
send a mail with an attachment in asp.net
I want coding for How to mail Send with attachment in using C# asp.net ....
View 1 RepliesI am getting following error .when i try to send a mail with attchment.
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 2/26/2010 4:42:47 AM Event time (UTC):
[Code]....
i had a requirement to attach a pdf document to mail.
i have attached the document the text is not displaying in the attachment.
here i had attached the code for reference.
string sSubject = "Automatic Email during Pinpair Activation";
string sEmail = "vidya@silkmedia.net";
string sAttach = "Silkconference_details-PDF-dial out.pdf";
string file = HttpContext.Current.Server.MapPath("~" + @"DocumentSilk Conference-Details-PDF - dial out.pdf")
byte[] bytes = System.IO.File.ReadAllBytes(file);
MemoryStream stream = new MemoryStream(bytes);
stream.Seek(0, SeekOrigin.Begin);
EmailUtils.SendEmbededImageEmailAttach(sSubject,sbEmailContent.ToString(),sEmail,sAttach,stream);
DECLARE
CUR_EMP_BIR REF CURSOR;
BEGIN
dbname.EMPLOYEE_P.EMPLOYEEBIRTHDAYSEL ( CUR_EMP_BIR );
END;
ORA-06550: line 2, column 19:
PLS-00201: identifier 'CURSOR' must be declared
ORA-06550: line 2, column 15:
PL/SQL: Item ignored
ORA-06550: line 5, column 45:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
[code]...
I have an ASP.NET application that uses an Oracle backend. I want to be able to step into the Oracle packages and stored procedures during debugging.
Is this possible and if so what toolset would be needed?
in my asp.net application, i am calling a stored procedure (oracle) to get some values from database.
Following is the sp:
[code]....
how to call this sp from my asp.net code.
I am goig to execute an oracle store procedure using C# through through ODP.NET. The store procedure executes succsfully but it does not return any value in the out parameter.
When I execute the same store procedure with the same input parameteres from within SQL*Plus. It does return values.
This is to be clearify here that in the oracle store procedure the data type for the out parameter is number and in the c# the variavle that will hold its value is Integer. I also tried using Long on the C# side but it is still not working. After the successfull execution of the store procedure the C# variable contains nulll value.
i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like..PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;
View 1 RepliesI would like to use a technique for exception handling on our database stored procs whereby, each proc exposes a p_error_code output parameter of type int. 0 indicates no error, and other values indicate application specific exceptions. Now, where a stored proc will return a ref cursor if no exceeptions occur, we would like to check the p_error_code and if not 0, then use the ref cursor. If an exception does occur, then the stored proc may or may not have populated the ref cursor, but the dotnet code will almost definately not read the contents.
OracleCommand command = CommandFactory.CreateCommand(transaction, "RTS.p_get_audit_trail");
We have an ASP.NET web service that invokes a stored procedure on our DB (Oracle 11g). The problem is that the call to the procedure blows up every time an empty string is passed as one of the parameters. We're seeing an ORA-01084 error, which indicates to me that call is failing before the procedure is actually run.
Here's the procedure, minus some logic that I believe is not relevant:
[Code]....
As an experiment, I modified the web service to pass null rather than an empty strings. When null is passed in, I see an error indicating "wrong number or types of arguments in call to 'CREATEREPORT."
I also tried passing DBNull.Value whenever the params were null/empty, but that resulted in the error
Parameter 'p_column_id': No size set for variable length data type: String.
(Of course, p_column_id was the empty parameter in this case).
So, how can I successfully pass empty strings as parameters to my stored procedure? We definitely want to allow the p_column_id parameter to be empty.
I've downloaded OracleHelper.cs & i'm using it for SELECT Statements so far &
Now i'm suppose to INSERT & UPDATE with it....
Will someone give an example for how to insert & update using oracle helper for TEXT & STORED PROCEDURE !
List<OracleParameter> OrclParam = new List<OracleParameter>();
OrclParam.Add(new OracleParameter("@eid",OracleDbType.Int32).Value) = a_type;
OrclParam.Add(new OracleParameter("@ename",OracleDbType.Varchar2).Value) = a_name;
OracleHelper.ExecuteDataset(connectionString, CommandType.Text,
"Insert into Employees (EID,ENAME) values(@eid,@ename)");
The above codes does'nt work
we recently upgraded an application (.NET 2.0) that we maintain to use Oracle 11g. The application uses MS Enterprise Library 2.0. We've found that when the database.ExecuteNonQuery(Oracle.DataAccess.Client.OracleCommand) method is called, it bombs when the stored procedure expects a parameter as a number, but receives a string. This didn't happen prior to upgrading. If I cast the parameter to an Int, I don't recieve the error. Was something possible missed during the upgrade? The issue occurs regardless if we are hitting an 11g database, or a 10g database.
EDIT: I neglected to mention that this same issue does not occur when ExecuteDataReader is called (handles implicit conversion of the datatype).
i have task to send mail to all my clients in one click
i have no idea for that
i think for each loop will be useful ??
i have a stored procedure and i want to return a value from that procedure and returned value i want to store in a variable Stored Procedure is create procedure simpleproc(OUT pcount int)begin set @pcount=(select count(*) from testtable); end
Now i call this proc from C# code
string query="CALL simpleproc(@count)";
MySqlCommand commond = new MySqlCommand();
MySqlParameter returnValue = new MySqlParameter("@count", DbType.Int32);
returnValue.Direction = ParameterDirection.ReturnValue;
commond.Parameters.Add(returnValue);
commond.CommandText = query;
commond.Connection = con; // I already set the connection in con and opened it
commond.ExecuteNonQuery();
int count = Int32.Parse(command.Parameters["@count"].Value.ToString());
What should i have to change to get return value in count
var a=conn.getData2();//getting the value from a global class conn.cs
OracleConnection con = conn.s();
OracleCommand oc = new OracleCommand("logedin(I need to pass the value here)", con);
logedin is strored procedure :-
create procedure logedin(user_id in int)
as
begin
update user_details set status='logedin'
where userid=user_id;
end;
i would lke to pass the value into the stored proc that was retrieved by the variable into the database.
I'm not so familiar with stored procedures but I'm interesting in moving most of my web selects to stored procedures. I'm working with .net based website and all my data access is something like this:
[Code]....
But now I want to improve some process and make tunings. For that I want to use stored procedures, so instead of the "SELECT ...." sentence I'll put stored procedure name. My problem is how to return a table from one.
I am using PL/SQL Developer.I have a below query select distinct
DATA_SRC_CD as Source,
FILE_NM as File_Name,
PATH as File_Path
from PKG_SFI_REPORTS.DATALOAD2SUMMARYETLRPRT("FACTS","CM_DDL_PARTY_2011_01_12_08_24_09.DAT")
In the above Query PKG_SFI_REPORTS => Package, DATALOAD2SUMMARYETLRPRT=> Procedure.
"FACTS" and "CM_DDL_PARTY_2011_01_12_08_24_09.DAT" => Parameters
Now I need to know the Data Types of "DATA_SRC_CD" and "FILE_NM" and "PATH". How can I Know?
I'm using the MySQL as back end , huge stored procedures are there. Is there any way to debug them using Visual studio 2008 or any other products.
View 4 RepliesI am currently developing a web application which need to encryption mail + its attachment file using method triple DES with signed using certification.
View 2 RepliesI have a req in which I have to call an AS400 stored procedure.The stored has an input and output parameter.
View 9 RepliesI am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?