cursor in forms 6i
I am working on form6i and using case expression in cursor.But the following code is not compiling Is Forms 6i not support the case expression in cursor or any method to write case expression in forms ...
oracle
How should I start profiling/optimizing my java application/oracle database?
Yesterday I read something abouth application optimization and how a programmer should find the most used parts of the program and by profiling and modifying them getting the most benefit (when looking at the time/work invested vs. memory/speed gains). Now, I've run the Eclipse profiler, got VisualVM but I don't how to use this data prop...
Calling Oracle stored procedure from Java
I'm calling an Oracle stored function using JDBC thin driver. Following is the code. class testSP { public static void main (String args []) throws SQLException, ClassNotFoundException { String driver_class = "oracle.jdbc.driver.OracleDriver"; String connect_string = "jdbc:oracle:thin:@xxx.xx....
Insert problem in oracle database
HRESULT: 0X80040E2F (DB_E_INTEGRITYVIOLATION) Error message: Value violated the integrity constraints for a column or table. Can anybody tell me how to solve this error. ...
what is the error in this program?
I have write the following pl/sql program and unable to dectect the error : declare variable a number; b number:=2354; begin b:=:a; end; the error in this is SP2-0552: Bind variable "A" not declared. plz help ... ...
(PLSQL) What is the simplest expression to test for a changed value in an Oracle on-update trigger?
Here is a boolean expression that does the trick: nvl(:new.location != :old.location, (:new.location is null) != (:old.location is null)) But I would like to think there was a simpler expression. Any ideas? ...
Optimizing the data access layer
Hi, all. I have a web service (JAX-RS/Spring) that generates SQL queries which run against a temp table in Oracle. The data is then archived to another table (through 3 MERGE statements). The execution of each "job" (querying and merging) is done in the background through a JMS broker (ActiveMQ). The sequence of operations of each job i...
How to modify .xsd in visual studio 2003 to add/delete columns from a table
I have an existing visual studio 2003 application that uses .xsd (connect to oracle db). I need to modify one of the tables in the .xsd file but when I save the .xsd file, I get build errors. What is the correct way to modify the .xsd file so that the application doesn't throw compile errors? ...
Deploying ODP.NET WPF application
Background: I developed a small .NET 3.5 WPF application that connects to an Oracle 9i database. Thinking that the ODP.NET version had to match the database, I downloaded and used an [older version][1] (9i, release 2, to be more specific) of the Oracle Data Access tools. I'm basically done the application now and need to deploy it. Th...
Oracle SQLPlus: Underline format when computing sum on multiple columns
Hello, I am computing the sum of multiple columns on the same break, but the output only displays a dash (-) underline between the last record and the column totals for a single column only...and it appears to always be the second column upon which the sums are being computed. Is there a reason for this and a way to apply the underline...
anyone used memcached with oracle ?
Just want to know your experience of infrastructure using memcached as caching solutions with Oracle database. Oracle's caching solution, TimesTen, is very expensive in terms of licensing cost ...
How to encourage myself to switch to ORM?
I'm working with a legacy project of my team-mate (.NET/Oracle). The project is not yet completed, it's under construction and far from production. He followed a "traditional way" to access data, which is creating stored procedures and then use database driver to call them. I want to follow a "modern way" to access data: use an ORM to ab...
SQL Server / Oracle : Private temporary tables
In Oracle, you can create a temp table using something like: CREATE GLOBAL TEMPORARY TABLE temp_table ( field1 NUMBER, field2 NUMBER ) ON COMMIT DELETE ROWS; ... which could be pretty nifty, as this creates a table visible to everyone, but the data one INSERTs into the table is visible only to him or her. Additionally, that da...
Calling Oracle functions from EJB in Seam framework
Hi, I am using seam framework and struggling to call a Oracle function. In my EJB, I am creating a namedQuery and when I call my entityManager.getResult() I get the following error: PLS-00222: no function with name 'jjhg' exists in the scope. (jjhg is the name of my oracle function) Please help. This is a bit urgent for me ...
Oracle ceil for decimal numbers
When rounding up to 2 decimal places, the value 4.01132141 would be rounded to 4.02 because it exceeds 4.01. How can you do this in PL/SQL? ...
Oracle BLOB vs VARCHAR
Hi. I need to store in a column of a table a SQL query (it's going to be a large one) and I thought using a BLOB field. What's best to use: BLOB or a VARCHAR ? Or something else maybe? Thanks for any ideas. C.C. ...
How to access help pages from SQL*Plus prompt?
Does SQL*Plus provide the help pages for its commands? Is there a way to access the help text from the SQL*Plus prompt, like this text for STARTUP? I tried SQL> man startup SP2-0734: unknown command beginning "man startu..." - rest of line ignored. SQL> startup -help SP2-0714: invalid combination of STARTUP options SQL> startup --help ...
Oracle: enumerate groups of similar rows
Hi all! I have the following table: ID | X 1 | 1 2 | 2 3 | 5 4 | 6 5 | 7 6 | 9 I need to enumerate groups of rows in such way that if row i and i-1 differ in column X by less than 2 they should have the same group number N. See example below. ID | X | N 1 | 1 | 1 2 | 2 | 1 3 | 5 | 2 4 |...
Complex ordering in SQL Query: possibly using CASE WHEN
I have a complex prioritisation algorithm that I want to write in SQL to when return prioritised pages of data. Some of these are prioritised according to fixed values, other are ordered by variable values. i.e. // Initial sort on ATTR1 (value1/value2 is higher than value3) if ATTR1 = value1 or value2 then orderBy creationDate, then ...
Choosing betwen JDBC or ADO.NET, performance studies on Oracle
Hi, We are starting a new project, wich talks to an Oracle database with millions of data. The system is mission critical and should be highly performant. We are now choosing the technologies that will be involved in the system, and we are doubting between JDBC or ADO.NET for data access. Wich technlogy is most performant? Are there a...