Return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle
I am wondering if anyone in this community knows the shorter way to return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle, something likereturn (IDataReader) SqlHelper.ExecuteReader(ConnectionString, "GET_ACCOUNT", Id);
instead of using the way below (look at the C# code)
Stored Procedure create or replace PROCEDURE "GET_ACCOUNT"
p_ID IN ACCOUNT.ID%type, retCursor OUT SA.MYGEN.sqlcur
OPEN retCursor FOR
ID = p_ID
...which is shou i use? Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NETI am confused?Which is better or which one should I use?BTW, I am going to use .net 2.0 with oracle 9. Can anyone tell me what shou I use for working with oracle database?Thanks very much in advance!Justin
Oracle's data provider has more functionality than Microsoft's.If your doing transaction processing you can have SAVEPOINTs, which Microsoft's data provider does not provide.Also, Oracle has PL/SQL Associative Arrays which are very powerful.Oracle also allows you to bind parameters by name and pos...urgent: .NET Provider for Oracle or Oracle Data Provider for .NET
If I want to access Oracle DB in ASP.NET application, and I am using .NET Provider for Oracle or Oracle Data Provider for .NET, should I have to install OracleClient on my .NET server? Is there other choice? Thank you very much.Johnson
Johnson2007:should I have to install OracleClient on my .NET server? You have to options1. install the ODP.NET on your web serverOR2. put the oracle assemblies in your BIN directory
Hi jimmy,Thank you for you reply. Because I could not find a server right now, I should test it first before I agree or disagree with you, as most articles I...How call a Oracle Function using Microsoft .Net Oracle Client (System.Data.OracleClient)?
I try to call Oracle Function in .net C# by using System.Data.OracleClient. But i am not successful.
Here is my code
( vten varchar2)
RETURN boolean IS
select monthethao_id into montt_id from TTHAO_MONTHETHAO
where ten = vten;
if montt_id!=-1 then
when others then
I do not know, when I call function TTHAO_MONTT_E...Problem with Oracle Stored Procedures using ODP.NET in VB.NET (VS 2003)
This is the stored procedure,Procedure RetrieveReservations(pProperty In Varchar2,pResHeaderId In Varchar2,pEmail In Varchar2,pPasswd In Varchar2,ResultSet In Out ResCursor);This is the old .asp code (part of it)objConn.ConnectionString = Application("BackEndConnection_ConnectionString")objConn.Open
objComm.ActiveConnection = objConn
objComm.CommandText = "internet_package.RetrieveReservations"objComm.CommandType = adCmdStoredProc
objComm.Parameters.Append objComm.CreateParameter("pProperty", adVarChar , adParamInput, 8, Request.QueryString("propid"))objComm.Parameters.Append objComm.Crea...Sending SMS using vb.net or C#.net using vb.net or c#.net
My requirement is
I hav one csv file with these fields id,mobilenum,messgae,status.intiallu staus is 0.
once i read the all fileds and take that mobile number.using tat mobile number i need to send sms .after sending sms i shuld change status as 1
How to send sms thru coding (please dont provide any links.if it is provide also please give working links becox i checked codeproject .i didnt get any nice link.
and also provide the how to update the status field im csv file
To send SMS, you need some third party SMS providers. if you consul...Oracle store procedure problem using Powerbuilder and Oracle 126.96.36.199 Net
Powerbuilder version 6.0.00 / 6.5 Build 444
Oracle Net 188.8.131.52
I found there is problem with Oracle store procedure having more than 6 in
parameters. I got GPF error on Window 95 and Dr. Watson error on NT.
Also, I found it works find in Oracle Net 184.108.40.206. Is this a bug? Is
there any new patch for this if it is a bug. Any recommendation about What
version Oracle Net or SQL Net should I used for Oracle server version
220.127.116.11 (I don't think I am using any Oracle 8 new features)?
Thanks in advance,
If you use PB 6.5, you can try the new Oracle 8 driver:
ftp....NET Oracle Provider
Hi all,I am using .NET 2.0 Frameworks Oracle provider and it does not have a OracleDbTypes Type for me to use. I would like to create a parameter that is of the Oracle type NVARCHAR, but it seems I can only use DbTypes, which does not have this. If I used DbTypes.String, would this be ok, otherwise, how else can I be more specific about the Oracle Parameter data type?Thanks
can u explain which type of data u r going to storeThank uBaba Thank uBabaPlease remember to click "Mark as Answer" on this post if it helped you.
What's your version of ODP? You have OracleD...Oracle ODP.net mulitple Oracle Client
To connect to the oracle database using ODP.net, the applicate must add the dll file called Oracle.DataAccess.
There are a lot of version of Oracle.DataAccess. As I know, if the client use Oracle Client 10g Release 2.
If the client use Oracle Client 10g Release 2, the application also have to use the Oracle.DataAccess the come from Oracle Client 10g Release 2.
My question is that there are any method to add more than one Oracle.DataAccess version in my product to support multiple OracleClient.
That should automatically happen for the most part. Oracle's ODP.NET i...Which .Net Provider for Oracle 9i Microsoft or Oracle
Can anyone provide me pros and cons of provider to access Oracle Database ? I am aware of Microsoft Provider and Oracle Provider.
I guess you can use either. But as some post suggests, if both installed, then MS ODP will not work.
I've been using DataDirect Technologies Connect for .Net and Oracle. It's not free, so it depends on your budget.
The speed improvements were great for us, and it's ni...OleDb.Net vs. ODBC.Net Connection to Oracle
I want to connect to an Oracle database, and I understand that I can use either the OleDB.Net data provider or the ODBC.Net data provider for my connection. Does it matter which one I use? What are the advantages and disadvantages of each?
Would appreciate any input.
ODBC is slower than OleDb. because ODBC has to talk to OleDbProvider then OleDbProvider will talk to Oracle Db. Instead if you are able to use OleDb straight to DB then it will be faster.
If you only have THOSE choices, I would take OleDb over ODBC any day. If you are using Framework 1.1, you have the choice of using th....Net with Oracle
Anybody has tried to develop mobile app. with .Net against an Oracle database?
Any idea to synchronize the data record between the database server and the client (pda) data.
It will be great if you could share your codes / experience.
Thanks a lot.
...How use unicode in Oracle with ADO.NET
I created one table in Oracle by statement :
create table Test2
and I write one application by C# to insert data into Oracle Database :
OleDbConnection conn = new OleDbConnection("Provider=MSDAORA;Data Source=hbk;Persist Security Info=True;User ID=hbk;Password=hbk;Unicode=True;");
OleDbCommand cmd = new OleDbCommand("insert into Test2(ID,Ten) values(10,N'Nguyễn thị hồng nhung')", conn);
I retrieved data that inserted by snip code:
OleDbConnection conn = new OleDbConnection("Pro...How to use Oracle as backend for .Net appliations
If I want to use Oracle as my backend, wat configuration settings I need??
System.Data.SqlClient is there but not OracleClient. what namespace is required for my appliation?
Thanks in advance.
There is System.Data.OracleClient namespace. You just need to reference Oracle.DataAccess.dllLeon LangleybenMCSD, ASP.NET MVPBlog
Actually, Oracle.DataAccess.dll is part of Oracle's data provider for .NET.If you are wanting to use Microsoft's Oracle data provider you will need to add a reference to System.Data.OracleClient.dll--dweezilSELECT * FROM users WHERE ...vb.net function and Oracle procedure to get an Oracle Dataset??
I have similar code (a procedure and function) working perfectly with a sql server data source. I;'m trying to do the same things with Oracle, but have run into the problems.
I'm not an oracle expert, so I'm not sure if producing a cursor is my only and best option.
create or replace package body PK_RETAILER isPROCEDURE sp_Get_Order_History(v_ani IN number,output_cursor out PK_CURSORES.generic_cursor) ASBEGINopen output_cursor forselect o.account_number, p.phone, o.amount, o.name, o.init_datefrom orders ojoin users_phones p on p.account_number...