oracleclient

Anyone know how to open new page in another window using OAF other then LOV

Anyone know how to open new page in another window using OAF - Oracle application framework other then LOV. I tried with JavaScript but due to security reasons i can not use it. just wondering if there is a way in OAF to achieve this. Thanks Imran ...

OracleClient, intermittent connection issue: app hangs on OracleConnection.Open(), no timeout, no exception thrown

Application works fine and connects every single time from any machine except the server, where it's supposed to be deployed :/ When run on the server it manages to connect once in like 20 or something attempts. Judging on the funky symptoms, I suspect it to be some kind of a network configuration related issue (as in some randomly lost ...

How do I create an instance of Oracle.DataAccess.Client.OracleException to use with NMock

I'm using the Oracle.DataAccess.Client data provider client. I am having trouble constructing a new instance of an OracleException object, but it keeps telling me that there are no public constructors. I saw other having the same problem and tried their solutions, but they don't seem to work. Here's my test code: object[] args = { 1, "T...

Good Oracle database development and management tool on Windows

I'm looking for an Oracle database management tool like sql server management studio. I've searched the internet and found a lot of tools on the following link: http://www.freedownloadscenter.com/Search/oracle.html. But I don't know which one is better. I need a stable and easy-to-use GUI tool for working on windows. ...

I have problem to connect oracle DB with SQL developer

I try connect to my oracle db with oracle SQL developer and received that message: pic (pictures 1 and 2) if i try connect with sql plus, all well. command : select userenv('LANGUAGE') from dual; result: Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> select userenv('LANGUAGE') from dual; *USERE...

Why do I get ORA-24784: Transaction exists? Standard code snippet, C#, ADO.NET, OracleClient.

I am a beginner in this area, but the code I write is right out of my textbook (Professional C# 2008, from Wrox). The example in the textbook is about Microsoft SQL Server, so the problem is most likely related to the fact that I work against an Oracle database, using System.Data.OracleClient: OracleConnection conn = GetDatabas...

What is the alternative for System.Data.OracleClient.OracleCommand?

Can anyone share a link to sample (ASP).Net code that uses the new Oracle Data Provider.Net library? I have code a web application code that uses the System.Data.OracleClient classes and want to migrate to the new Oracle Data Provider for .Net. Thanks ...

ODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger.

I am new to Oracle, and there is an issue I am facing. When I run the application from IDE - Visual Studio 2005, The database connection is established smoothly, but when I run an installed version of the app, the DB connection fails and I get a TNS: Connect timeout occurred error. I tried with SQLNET.ORA and similar solutions found onl...

How to validate prerequisite for ODP and Oracle Client connection

Hi. I have a very simple application on .Net that connect to Oracle using ODP (was compiled with Oracle.DataAccess dll 10.2). I want to check "connection prerequisite" (application will be able to connect to DB) before installing this aplication on other computers? How can I check that ODP.NET version 10.2 or higher is installed on tar...

unable to import dump using "imp"

I am trying to import into oracle using imp command and the output of the command is as below. invincible:/home/invincible# imp Import: Release 10.2.0.1.0 - Production on Thu Aug 12 22:19:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: n_data Password: IMP-00058: ORACLE error 1034 encountered ORA-01034: OR...

Oracle SQL Developer - Query results window with grid missing

I've just made the switch from MS sql server to Oracle. The query tool I am using is Oracle SQL Developer. The problem I am having is that I cannot get the query results window to stick around. The query results window being the Grid view for the results. It seems to show up arbitrarily when I open a new "sql worksheet". But not alwa...

Oracle Instance Client Light (odac 11) and character sets

Hi! I am trying to connect to oracle db without full installation of oracle client done on the machine. I found this helpfull post Using the new ODP.Net to access Oracle from C# with simple deployment but when I try it, I am failed on the next exception: [Oracle.DataAccess.Client.OracleException ORA-12737: Instant Client Light: unsupp...