CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums



> Asp.Net Forum > data_access.oracle
 TypeRepliesViewsDate
Using Oracle Express Edition With Visual Studio 2008

I am sorry if this is a basic question, but I can't seem to find a solution while browsing the web. I have Oracle Express Edition (OracleXE) Version 10g.    I need to know how

 04011/29/2009 10:04:10 AM
Problem with Calling Oracle Stored Procedure from asp.net (VB)

 

Dear all,

I'm calling oracle stored procedure which i have tested directly form oracle and it works fine but when I tried to call it from asp code it gives me wrong arg

 04411/26/2009 6:35:45 AM
Header to Excel File

 

Hey There;

I have a little problem about adding a header to my excel file on a procedure

Here is my procedure:

 

 

04211/20/2009 1:32:08 PM
Time table

Can ? create a time table using ORACLE SQL, I can not use PL/SQL

               09:00 10:00 11:00 

Monda

 03911/20/2009 9:06:40 AM
BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess '

I have an application build from Visual Studio 8 that is using the System.Oracle.DataAccess library to talk to an Oracle DB. This dll is version 2.111.6.20 x86 version.

<		 04511/20/2009 12:21:21 AM
BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess '

 

I have an application build from Visual Studio 8 that is using the System.Oracle.DataAccess library to talk to an Oracle DB. This dll is version 2.111.6.20 x86

 03311/19/2009 10:48:17 PM
Oracle ORA-12154 TNS Could Not Resolve Service Name

I have an application that works great locally.  When we moved it to our test server (running Windows 2003, .NET 3.5, Oracle 9i Client 9.2.0.7.0) it returns the stack trace below.&

 04111/19/2009 5:52:40 PM
Number-type output parameters - need to use ToString() first

We recently upgraded our Oracle Client.  I started getting this error:

Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal&

 04111/18/2009 3:18:46 PM
Tree in SQL

How can do it in ORACLE SQL. I can not use PL/SQL

http://forums.asp.net/p/1493909/3517882.aspx#3517882&nb

 03411/17/2009 5:12:57 PM
How to synchronize data of different oracle database ?

Hi all

I am using oracle database,

Database db1          

Table:   tlbdb1_City1

 

Databa

 03311/17/2009 10:51:27 AM
Save PDF file in oracle

Hi,

Any suggestions to upload and download PDF files from ORACLE database ,in ASP.NET web application.

Thanks



 04311/16/2009 11:13:15 PM
Time problem

in the dable the date is insert; 03/04/2009 03:00:00 PM. I want to call the time 15:00 not 03:00 PM. How can do it ?

Thanks .

 

 04811/15/2009 6:44:57 PM
Datasource query column name parameter

hi all,

can i set parameters column name in datasource select query for Oracle ?

Select id, name, sname from person p where :pColumnName = 1234


pColumnName i

 04011/14/2009 4:46:42 PM
Financial Years in a Query Result

Hi all,

I need to get a result of financial years(...2006-07, 2007-08, 2008-09) starting from the date given by me to till year in oracle.

I have no idea of how to do th

 02511/12/2009 8:23:54 AM
Uploading .CSV file to Oracle Tables

 

Hey There;

In my application, I'll have a menu item for uploading and in this menu, I will upload .csv file and columns in that file will be written to the database tab

 04411/11/2009 10:32:47 AM
ODBC Role Providers in .NET

hi all,

iam working with asp.net and oracle database,i need to maintain different roles
in my application.

please let me know any role providers and membership provide

 03911/11/2009 9:18:08 AM
Interop.OracleInProcServer sdo_geometry problem

Hi,

I use COM library OracleInProcServer but I can not get sdo element info:


string sql = "SELECT * FROM GEOMTABLE WHERE ROWNUM &l

 04511/11/2009 9:18:07 AM
Invalid Number

I can take "Invalid Number" error in this sql query. Whats wrong :S. One  eek ago, the code it work, buk today not :(  Thanks for your helping

SELECT 'The result i

 03311/11/2009 9:18:04 AM
dealing with Oracle store procedures

Dear all,

I'm trying to call stored procedure, but I'm having error and I don't know why it's happening?I'm new at this

 Her

 03811/11/2009 9:18:01 AM
appending data from the oracle to grid using storedprocedure

Hi

iam using asp.net and c# and oracle,

in my app i created one stored procedure

CREATE OR REPLACE
PROCEDURE GetCustDetails(p_recordset1 OUT SYS_REFCURSOR)

 04211/11/2009 9:18:00 AM
Databind() of my data grid taking forever to execute

OracleCommand cmd = new OracleCommand(SQL, conn);
OracleDataReader dr = cmd.ExecuteReader();
grd1.DataSource = dr;
grd1.DataBind();

 

<		 04511/11/2009 9:17:55 AM
lost system password

Hi..

Please provide the way, how i can change the Oracle "System" password.

I lost my Oracle "System" and "Sys" passwords.

How i can recreate a new

 04111/11/2009 9:17:53 AM
Not able to connect to Oracle using OleDbConnection

Hi,

 04311/11/2009 9:17:50 AM
Help me with oracle sql not picking values?

I am developing web application using Csharp and orcale as database.I have 2 problems.

1 when I run the sql  below it is not picking the value even when they is a value. Where I a

 03511/11/2009 9:17:47 AM
Select field twice

Hi ALL,

I have a table  that save employee number for flow of approving requests and sequence number for each one

I want to retrive name of every one who have sequence numbe

 04411/11/2009 9:17:45 AM
Many Oracle Client Homes

Dears,

I have two oracle client installed on same server (Win 2003 server). OraClient10g_home1 and OraClient11g_home1.
OraClient11g_home1 is the default.
what i want

 03711/11/2009 9:17:43 AM
Help me to understand the Stored Procedures in Oracle.

I am develepiong web application using csharp. I  have been learning  how to use stored procedures, so Have no experience in these.I got the stored procedures from internet below. But I

 04011/11/2009 9:17:41 AM
Help me with Stored Producures Examples Csharp .NET

Hello People,
Can someone help me with clear example of store prucedures used to retrieve records from oracle database in Csharp.NET. An example  that will help me to  understand t

 04111/11/2009 9:17:33 AM
unimplemented or unreasonable conversion requested asp.net

Hi all, I am uploading a .doc file to a BLOB column: if I do the operation  I get "

Error Code=-2146232008

 "ORA-01460: unimplemented or unreasonable conversio

 03211/11/2009 9:17:32 AM
ORA-00932: inconsistent datatypes error

I have cursors set up to return various count(*) s. Im getting the inconsistent datatype error and not sure why. Snippet of code below. Do I have to define an actual datatype in the cursor or s

 04311/11/2009 9:17:23 AM
ORA-01017: invalid username/password; logon denied

I get this message when trying to connect to Oracle database from ASP.NET. Username & password are correct, IIS installed. Here is my code:

 04011/11/2009 9:17:21 AM
uploading file

dear all;

              i am using asp.ne uploading control in my application ... so i

 04311/11/2009 9:17:18 AM
How can I use blind variables in oracle sql?

How can I use blind variables in oracle sql? Please give an example

 03911/11/2009 9:17:14 AM
login with oracle

dear all;

           how to use asp.net login with oracle ....  and why we use membership with oracle database 10g and HOW???

<		 03411/11/2009 9:17:11 AM
Loading file from user to insert in th DB

Hi.

I have a simple website, where user could upload CSV file.
My application must parse the rows and insert them into table in the database(oracle 9)

Problem with encoding of th

 05111/11/2009 9:17:08 AM
How to create TableAdapter for Oracle stored procedure with T_CURSOR output param

Hi All,

I'm trying to call Oracle stored procedure with T_Cursor output parameter to produce TableAdapter (Dataset Schema xsd)

Any idea how to do that?

Thanks in

 03411/11/2009 9:17:06 AM
How can I avoid duplicates in sql with Joins?

Hello People,
I am developing web application using csharp and oracle as a database.  I have a three tables where I am pulling from records. But when write sql using inner joins and Out

 03511/11/2009 9:16:57 AM
Problem in Oracle connectivity

Hi All,

I have installed oracle 10g in my system and everything works fine in oracle sql*plus.

The problem is

When i implemented this in c# it throws error "Untitled Page

 04411/11/2009 9:16:56 AM
ORA-00942 while fetching Data from view - query works perfect in toad

Hi guys,


I'd been on this thing for two days now and now I beg you for help.


I have a "view" ISASDBM.ISAS_FAC_MCS and I'm trying to pull da

 05011/11/2009 9:16:52 AM
Configure Oracle for NHibernate

Hi Everyone,

I want to configure NHibernate with Oracle database, as of now all the connection string and property of nhibernate are configured correctly, but when i run the applicat

 03911/11/2009 9:16:50 AM
Calling oracle package procedure in c#
Hello folks, I have a proc inside a package. This proc creates a temporary table and after that i run a select command (commandtype.text) joinning this temporary table with database tables. If i		 02911/11/2009 9:16:50 AM
Update Statements Not Working

I am attempting to update an Oracle 10g table with the following code.

db_command = New OracleCommand(

 01115/19/2008 10:26:41 PM
OracleParameter Problem - not getting full value in varchar parameter

Hello, I have come accros this problem, altough I have been using this code before I have an oracle command with 1 parameter

 

string cmd = " Select value from Database

 01015/19/2008 4:29:52 PM
How to List Tables in an Oracle Database

Hello Everyone,

 I am using Oracle's ODP.NET Version 10g (i.e. Oracle.DataAccess.Client) and need to know how to create a list of tables and views found in th

 4975/19/2008 2:14:06 PM
multiline command of oracle in asp.net

Hi All,

 

I want to use a multiline command for generating a text file from oracle database through asp.net coomand text

 

4935/19/2008 12:57:55 PM
Update command not working !!!

 

 

 

Hello everyone,

I'm using the following code to update date [ oracle database ] its not raising any error, but its also not updating [ exe

 21105/16/2008 9:04:01 PM
Writing to a CLOB (Oracle DB)

 I'm trying to write to a CLOB datatype in a Oracle database.  Just passing SQL works great if the string that I'm trying to store is < 4000 characters, but I needed a way to

 1945/16/2008 7:21:54 PM
Connection string works locally but not on server

I set up an Oracle connection that works locally, but catches an error and does not work when published to the server. I specified the driver in the connection string and confirmed that it i

 11085/16/2008 12:13:28 PM
Querying SqlServer tables from inside Oracle?

 I need to interactively query sql server 2000 data tables from inside Oracle, as part of packaged procedures, queries, etc.

Anyone done this?  Where do I need to get started?

 11055/16/2008 11:00:31 AM
Error when trying to fill Datagrid from Oracle stored proc

On an ASP.NET form I'm trying to populate a data grid with the following oracle codebehind code:

Dim Oraclecon As New OracleConnection("Data Source=####;User Id=####;Password=###

 11225/16/2008 5:45:53 AM
1840 Items, 37 Pages 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |< << Go >> >|


   
  Privacy | Contact Us
All Times Are GMT