Databases :: How To Use Oracle Stored Procedure To Send Mail With Attachment

Apr 10, 2010

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.


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.

View 1 Replies

Similar Messages:

Databases :: How To Call Oracle Stored Procedure

Feb 23, 2011

I would like to know if there is a way to call Oracle stored procedure from inside code?

View 2 Replies

DataSource Controls :: How To Convert The Oracle Stored Procedure To Sqlserver 2005 Stored Procedure

Apr 2, 2010

This 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

View 4 Replies

Send Mail With An Attachment?

Mar 3, 2011


send a mail with an attachment in

View 1 Replies

Web Forms :: How To Send Mail With Attachment

Apr 27, 2016

I want coding for How to mail Send with attachment in using C# ....

View 1 Replies

Web Forms :: Unable To Send Mail With Attachment

Feb 26, 2010

I 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):


View 6 Replies

Web Forms :: Attach PDF Document As Mail Attachment And Send Email

Jun 10, 2013

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 = "";
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);

View 1 Replies

Databases :: How To Execute An Oracle Stored Proc

Oct 14, 2010

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

View 4 Replies

Databases :: Stepping Into Oracle Stored Procedures?

Feb 26, 2011

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?

View 6 Replies

Calling Oracle Stored Procedure From Application?

Jan 13, 2011

in my application, i am calling a stored procedure (oracle) to get some values from database.

Following is the sp:


how to call this sp from my code.

View 2 Replies

Databases :: Oracle Store Procedure Does Not Return Any Thing In The Out Parameter

Oct 20, 2010

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.

View 3 Replies

Databases :: Error While Getting Record Set From The Stored Proc Of The Oracle

Jan 27, 2011

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 Replies

Databases :: Oracle Stored Proc Optionally Returning A Ref Cursor?

Feb 22, 2010

I 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");

View 5 Replies

Passing Null / Empty String To Oracle Stored Procedure?

Mar 1, 2010

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:


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.

View 1 Replies

Databases :: To Insert & Update Using Oracle Helper For Text & Stored Pocedure?

Sep 2, 2010

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

View 1 Replies

Oracle 11g Stored Procedure - Expects A Parameter As A Number, But Receives A String?

Mar 23, 2011

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).

View 1 Replies

Send Mail To All Email Address Stored In Database In One Click?

Dec 31, 2010

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 ??

View 11 Replies

Databases :: How To Return A Value From A Stored Procedure

Jan 5, 2010

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.CommandText = query;
commond.Connection = con; // I already set the connection in con and opened it
int count = Int32.Parse(command.Parameters["@count"].Value.ToString());

What should i have to change to get return value in count

View 4 Replies

Databases :: Pass Value Into Stored Procedure?

Jun 5, 2010

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)
update user_details set status='logedin'
where userid=user_id;

i would lke to pass the value into the stored proc that was retrieved by the variable into the database.

View 4 Replies

Databases :: How To Return A Table Through A Stored Procedure

Mar 24, 2010

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:


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.

View 3 Replies

Databases :: How To See Datatypes Of Columns When Using Stored Procedure

Feb 1, 2011

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
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?

View 3 Replies

Databases :: Debug Mysql Stored Procedure

Jan 18, 2011

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 Replies

ASP.NET MVC 2.0 : How To Sign An E-mail + Attachment File And Encrypt Both An E-mail And Its Atta

Aug 6, 2010

I am currently developing a web application which need to encryption mail + its attachment file using method triple DES with signed using certification.

View 2 Replies

Databases :: Calling AS400 Stored Procedure From C# Coding?

Sep 12, 2010

I have a req in which I have to call an AS400 stored procedure.The stored has an input and output parameter.

View 9 Replies

Databases :: Losing Connection When Running Long Running Oracle Procedure?

Jul 1, 2010

I 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:


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?

View 1 Replies

Copyrights 2005-15, All rights reserved