system.data.oracleclient

Constructing a good search query using system.data.oracleclient

I am constructing a search function in a class to be used by several of our asp pages. The idea is simple, take a search term from the user and query the database for the item. Currently I am doing this the wrong way, which is vulnerable to SQL injection attacks (and ELMAH is in there to save the day if something goes wrong): Public S...

Is there a way to force OracleCommand.BindByName to be true by default for ODP.NET?

Since the System.Data.OracleClient library has been deprecated, we are in the process of migrating our code base to use Oracle Data Provider for .NET (ODP.NET) instead. One of the issues that we have encountered is that the System.Data.OracleClient uses parameter name binding as opposed to binding by position and all of the code directly...

Help Optomizing Bulk Inserts into Oracle Using VB.NET

I am inserting a block of 5000 records at a time, one block right after the other. The commands are created in a seperate DLL and can call anyone of 4 different stored procedures. Is there a bulk insert method that might speed this up. Currrently it takes about 1.5 MS per record and would like to get this down to about .7 MS. Thanks,...

How Do You Insert Large Blobs Into Oracle 10G Using System.Data.OracleClient?

Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not ...

In C# Using System.Data.OracleClient.OracleParameter String Containing Single Quotes is Cut

I can't understand why but there seems to be a different behavior with my varchar parameters according to whether I'm in a transaction or not. I want to pass an OracleParameter, type VARCHAR, containing a single quote, such as: Dante's Lament When I'm NOT in a transaction, the string is passed correctly. When I'm in a transaction, ev...

Issues calling stored procedure from C# with large CLOB

Dear all, I'm not the first to have these issues, and will list some reference posts below, but am still looking for a proper solution. I need to call a stored procedure (Oracle 10g database) from a C# web service. The web server has an Oracle 9i client installed and I am using Microsofts System.Data.OracleClient. The procedure takes ...

ORA-06550, PLS-00306; Error inserting data to Oracle procedure.

Hi all, I have tried to troubleshoot this problem but to no avail. I get error while inserting a big chuck of data to Oracle package containing procedure 'INSCRAPP'. The error message is, ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'INSCRAPP' ORA-06550: line 1, column 7: PL/SQL: Stat...