Oracle Applications Concurrent Manager Job Owner
By default concurrent manager jobs are run under the APPS user. Is it possible to configure it to run as another user? I'd like to be able to isolate some of my stored procedures. ...
oracle
Oracle Floats vs Number
I'm seeing conflicting references in Oracles documentation. Is there any difference between how decimals are stored in a FLOAT and a NUMBER types in the database? As I recall from C, et al, a float has accuracy limitations that an int doesn't have. R.g., For 'float's, 0.1(Base 10) is approximated as 0.110011001100110011001101(Base 2) wh...
Access to multiple data sources using Oracle Brio
Trying to build a dashboard using Oracle's Brio. I have to access 6 different databases to grab the same type of data, aggregate it and display it. Except that when I do it, Brio grabs the data from the first source just fine. When I grab the data from the second data source, Brio replaces the original data with the second set. So I ...
migrate from oracle to mysql
Hi All, Pls, could you help me on the following issues: I would like to migrate from oracle to mysql and one of important step is to replace the actual job built on oracle environment; Basically every day I receive from other oracle environment some 'oracle' dump files (mainly CTL or oracle table exports). Today my oracle jobs load the...
"Session closed" error when trying to get a blob from DB using getBinaryStream()
I'm using Hibernate 3.1 and Oracle 10 DB. The blob is defined as @Lob @Basic @Column in the Hibernate entity which corresponds to the relevant DB table. The error -java.sql.SQLException: Closed Connection- seem to appear once in while, not in every attempt to get the blob from the DB. This seems like a hibernate fetching issue, so I tho...
Is "Commit" necessary when updating Oracle from asp.net?
I have this code protected void btnUpdateAddress_Click(object sender, EventArgs e) { sdsAddressComparison.Update(); } that I'm using to update an oracle database. When I run the update sql code in SQL Navigator I have to type "Commit" or hit the commit button. Do I have to code in a "Commit" somewhere in ASP.NET...
How to set Cursor type in JDBC?
I'm running tomcat and have some jsp pages that display a subset of a table. I show 20 rows at a time on a single page. When the table has large amounts of data, the jsp page doesn't render. I'm guessing that the ResultSet is using a client side cursor. I've worked with ASP in the past, and we always used server side forward only cur...
Rails + Oracle: worth hassle?
Is it architecturally sound to use Rails and Oracle? My concern is that Oracle would be too "heavy and hi-end" for Rails. Any thoughts? Thanks. ...
Oracle table change monitor
Hi Folks, I have a java application that is connected to a view on a remote Oracle db. Does anyone know of a way in Java to monitor this table for changes ? I.e. if there are inserts of updates etc I would need to react. Thanks in advance Len ...
Why does Oracle require TO_NCHAR when binding SQL_C_WCHAR text via ODBC
I use the following statement prepared and bound in ODBC: SELECT (CASE profile WHEN ? THEN 1 ELSE 2 END) AS profile_order FROM engine_properties; Executed in an ODBC 3.0 connection to an Oracle 10g database in AL32UTF8 charset, even after binding to a wchar_t string using SQLBindParameter(SQL_C_WCHAR), it still gives the error ORA-12...
Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC
I've got an insert into a table using ODBC 3.0 on Oracle 10g that is failing and I have no idea why. The database is on Windows Server 2003. The client is on Windows XP. The table: CREATE TABLE test ( testcol NUMBER(20,0) NULL ); The ODBC calls: SQLAllocHandle(SQL_HANDLE_STMT) = SQL_SUCCESS SQLPrepare(INSERT INTO test (testcol) VALU...
Is it possible to use ODP 11 xcopy deployment and not change the PATH?
I have an application that's using Oracle.DataAccess to connect. I've already discovered that the footprint can be lessened by using ODAC 11 with xcopy deployment. That's already a big win. Ideally, though, we would like to not have to alter any path variables and have all the ODAC files in a subdirectory underneath the application's ...
Execution order of conditions in SQL 'where' clause
I have a set of conditions in my where clause like WHERE d.attribute3 = 'abcd*' AND x.STATUS != 'P' AND x.STATUS != 'J' AND x.STATUS != 'X' AND x.STATUS != 'S' AND x.STATUS != 'D' AND CURRENT_TIMESTAMP - 1 < x.CREATION_TIMESTAMP Which of these conditions will be executed first? I am using oracle. Will I get these details in m...
Database design - Should a Date be used as part of a primary key
What are the pros/cons for including a date field as a part of a primary key? ...
Hiding/Locking tables in oracle
How do I hide/lock a few tables in Oracle so that only my application has access to modify those data in the table? ...
Bulk Insert to Oracle using .NET
What is the fastest way to do Bulk insert to Oracle using .NET? I need to transfer about 160K records using .NET to Oracle. Currently, I'm using insert statement and execute it 160K times.It takes about 25 minutes to complete. The source data is stored in a DataTable, as a result of query from another database (MySQL), Is there any bet...
Mapping ORACLE's NUMBER Type with Hibernate
Hello, I have a table in a ORACLE 10g database with a column "kzCode NUMBER(1)". If I try to map this with Hibernate annotations in JBOSS Server WebApp like this: @Column(nullable=false) private Integer kzCode; I got an error: org.hibernate.HibernateException: Wrong column type: kzCode, expected: integer I also tried @Column(nulla...
Multiple Answer Matrix in ASP.NET
I'm involved on a project to make a survey system. We've been hammering out the logic for a few question types, and I could use a second opinion on what is the best way to proceed. We work on a ASP.NET 2.0 website using VB(VS2005) with an Oracle database. In our oracle server, we plan for some tables to organize our data. There's a t...
VB and Oracle connectivity
What are the steps to connect to Oracle 9i with VB6? How can I use modules and stored procedures in VB6 and how can I call an SP? What is the method to use ADO which is helpful to insert, update, search and delete the items from the front end? Thanks ...
What are the advantages to each approach for mapping application end users to database users?
There seems to be three common approaches for mapping an application end user to a database user. One to One Mapping: Each Application user (bob, nancy and fred) also get a corresponding database user account (bob nancy and fred). N to M mapping: Each application user is mapped to a database user that represents their role. bob and...