I have a rather simple PL/SQL query (...) DECODE(upper(Table.Column), 'SOMETHING', '---', TABLE2.COLUMN2) as VALUE (...) How can I apply the WHERE clause using above statement, because when I use something like: WHERE upper(VALUE) like 'SOMETHING' it gives me an empty recordset (and I am absolutely positive that there are records w...
We encounter an OutofMemory error. I analyzed the *.phd file, that websphere dumps, using Eclipse Memory Analyzer. The Leak Suspect Report of MAT, provides the following information The class "com.ibm.rmi.io.ValueHandlerPool", loaded by "com.ibm.oti.vm.BootstrapClassLoader @ 0x466578", occupies 68,734,136 (50.25%) bytes. The memory is ...
Hello, I am a front-end developer writing a C# application to export data from an oracle stored procedure into a text file for later importing into a different oracle database. The data will be loaded with SQL Loader (sqlldr) and I am trying to understand that tool's abilities so that I can output the file in a format that will be easy ...
myTable UNID 9 10 UNID is a VARCHAR2 select max(UNID) from myTable returns the UNID with the highest lexicographic value (9). how do i select the UNID with the highest integer value (10)? ...
Hi everybody, I am currently tracing a performance leak in a stored procedure. Having a timestamp put out right after the initial "begin" and one right before the final "end" (I am doing a commit before) says the procedure takes abt. 10 secs to finish. However, I have to wait 2mins+ for it to end. Can anybody tell me where the rest of ...
I am designing a new laboratory database. I want to store the raw results for all tests together. However, results can either be a single measurement or a raw waveform. (repost see footer) Which case below is ideal (and why)? ... or provide your own ideal option. TEST test_id* (other TEST fields) OPTION 1: Separate single values...
Hi I'm currently working in the deployment of an OFBiz based ERP The database being used is Oracle 10g Enterprise One of the biggest issues is some oracle performance problems, analyzing the ofbiz logs, the following query: SELECT DISTINCT ORDER_ID, ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, ENTRY_DAT...
hi there, we would like to write a web based application to monitor the ATM machines in the bank to have the following functionality: Display location of each terminal Display general status of the terminal in color coding or simple icon (ATM up/Down/needs attention, low cash, etc.) Have a facility to drill down on the status of the...
Hello, I have a procedure and i would like that only one user could execute this procedure at same time. How i can do it? A lot of thanks! Regards Marc ...
I'm a newbie to Java-related web development, and I can't seem to get a simple program with JDBC working. I'm using off-the-shelf Oracle 10g XE and the Eclipse EE IDE. From the books and web pages I've checked so far, I've narrowed the problem down to either an incorrectly written database URL or a missing JAR file. I'm getting the fo...
I want to do something like this create type Item as object ( id number, subitems table of ref Item ) but oracle throws an exception when I try to do it. Is this possible, and if yes then how? ...
I have a table and two databases which have the same table, but one is a symlink of the other one and only read is permitted on this table. I have mapped the table to Java using Hibernate and I use spring to set the Entity Manager's data source as one of the two databases based on some input criteria. I call only read only operations ...
What is the SQL Server equivalent to Oracle's Virtual Private Database (VPD)? ...
When MS-SQL Server 2000 dtsx job tries to run, gets error "Ora-12154 TNS could not resolve service name" Tnsping to the oracle service to connect replies OK The Windows 2003 x64 Server that runs the dtsx jobs has 32 bit Oracle Server, ODAC 32 bit and Oracle Client 32 bit installed. Thank you for your concern , Kayhan YÜKSEL ...
can anybody help me in oracle10g in unix machine I have a requirement to execute the unix command in procedure how can i do that thanks in advance ...
I want to run a CREATE DIRECTORY query in Oracle 10, but it's giving me an insufficient privileges error. Can anybody tell me how to grant this privilege to my user through the system as a user? ...
Is it possible to retrieve the names of all procedures and functions that reside within a particular package? I understand that they can be gleaned (smells hack-ish) from the ALL_SOURCE view, but I would prefer a more canonical strategy. ...
I am designing a new laboratory database. For some tests, I have several waveforms with ~10,000 data points acquired simultaneously. In the application (written in C), the waveforms are stored as an array of floats. I believe I would like to store each waveform as a BLOB. Questions: Can the data in a BLOB be structured in such a w...
Hi all Currently working in the deployment of an OFBiz based ERP, we've come to the following problem: some of the code of the framework calls the resultSet.last() to know the total rows of the resultset. Using the Oracle JDBC Driver v11 and v10, it tries to cache all of the rows in the client memory, crashing the JVM because it doesn't...
I'm looking for a third-party Oracle Data Provider for .Net (ADO.NET) with a full support of Oracle object types (like geometries). I was foolish enough to use ODP.NET and now I'm paying the price - it's incredibly buggy and I just reached the end of the line (keep crashing IIS Pool - known issue, no resolution). I found dotConnect which...