I am using Eclipse Galileo and Tomcat 6.0. I am getting an error like this: 2010-08-17 00:09:42,684,JDBCExceptionReporter,WARN,,SQL Error: 0, SQLState: null 2010-08-17 00:09:42,684,JDBCExceptionReporter,ERROR,,Cannot create PoolableConnectionFactory (ORA-01033: ORACLE initialization or shutdown in progress ) 2010-08-17 00:09:42,684,Sett...
I am practicing SQL, and suddenly I have so many tables. What is a good way to organize them? Is there a way to put them into different directories? Or is the only option to create a tablespace as explained here? ...
I just observed a strange behaviour (of course Oracle is probably supposed to behave this way, but it didn't fit in my world view yet): I try to insert two rows into a parent and a child table, both within the same transaction: INSERT INTO V_Parent (ID, Name) VALUES (777, 'Hello World'); INSERT INTO T_Child (ParentID, Name) VALUES (777...
I have this simple query select * from users where name = 'User1' I'd like to extend the query's functionality whatever the query returns 0 records the query will fetch the data by other clause. where name = 'Default' If the first clause will fetch some records the second clause will be ignored. EDIT Oracle ...
I'm trying to call an Oracle stored procedure from my Java program. I'm using JDBC and Spring's StoredProcedure. A couple of the parameters are user defined types and I need to know how to pass them in. In particular what type should I specify in the parameter map (i.e. which of java.sql.Types.*)? And what Java type should I use? Th...
What would be the fastest way of retrieving data from the Oracle DB via OLEDB? It should be portable (have to work on Postgres and MS SQL), only one column is transfered (ID from some large table). Current performance is 100k rows/sec. Am I expecting too much if I want it to go faster? Clarification: datatable has 23M records Query...
I'm trying to do something which should be fairly simple, but in my experience with Oracle, nothing ever is...! I'm trying to call an oracle procedure in C# using MS provider for Oracle. As far as I can tell, there are the correct number of parameters, and the type of each parameter is correct. More importantly, if I run the procedure ...
I get the error java.sql.SQLException: Exhausted ResultSet to run a query against an Oracle database. The connection is via a connection pool defined in Websphere. The code executed is as follows: if (rs! = null) ( while (rs.next ()) ( count = rs.getInt (1); ) )...
I'm making my first forays into Accessing Oracle from C#. I've discovered that that Oracle doesn't like VarChar parameters to have value of null (C#). I would have hoped that there would be some implicit conversion, but I appreciate the difference. So I need to trap these null values and supply DBNull.Value instead, surely? The most obv...
I can't understand why but there seems to be a different behavior with my varchar parameters according to whether I'm in a transaction or not. I want to pass an OracleParameter, type VARCHAR, containing a single quote, such as: Dante's Lament When I'm NOT in a transaction, the string is passed correctly. When I'm in a transaction, ev...
I have a requirement where multiple tables need to be generated in oracle reports. I tried inserting an report block within a repeating frame, but doing so makes the application hang. Is there any valid way to do this? Thanks in advance. ...
I have rows in an Oracle database table which should be unique for a combination of two fields but the unique constrain is not set up on the table so I need to find all rows which violate the constraint myself using SQL. Unfortunately my meager SQL skills aren't up to the task. My table has three columns which are relevant: entity_id, ...
I am trying to make use Oracle's ability to deploy and invoke .NET assemblies within it. This requires connecting as SYSDBA. The weird thing is that I can connect as Normal and as SYSDBA from within PL/SQL Developer and I can connect as Normal from within Visual Studio, but get an "insufficient privs" error connecting as SYSDBA from Visu...
What SQL data type does Oracle assign to count(*) in a query like select count(*) from table? Does this depend on the count size? ...
What Java data type does the Oracle JDBC driver assign to the Oracle SQL data type NUMERIC? Does this vary with the size of the NUMERIC type? ...
When run against and Oracle database, what is the runtime type of the object that the following Spring Hibernate Template (Spring 2.5 and Hibernate 3.3.2GA) code returns where the SQL query is a counting query like select count(*) from table? String sql = "select count(*) from table"; BigDecimal count = (BigDecimal) hibernateTemplate....
The following SQL statement works in MySQL but not with Oracle: SELECT *, MAX(COLUMN_A) FROM table_xyz WHERE COLUMN_A <= 100 GROUP BY COLUMN_A Oracle complaint: "FROM keyword not found where expected" ...
Can anyone recommend a good tutorial (or book perhaps) that covers advanced topics in the use of Analytic Functions? I'm looking for something that covers both Oracle and SQLServer - or two separate guides if a single one doesn't exist. Something that offers good examples of using nontrivial functions (LAG, LEAD, GROUPING, PERCENTILE) ...
Is it possible to see the DML (SQL Statement) that is being run that caused a trigger to be executed? For example, inside an INSERT trigger I would like to get this: "insert into myTable (name) values ('Fred')" I read about ora_sql_txt(sql_text) in articles such as this but couldn't get it working - not sure if that is even leading me...
I have an oracle function which is given below. when i run this in sql-developer it gives an error ORA-06502: PL/SQL: numeric or value error: character string buffer too small error. However the DBMS_OUTPUT.PUT_LINE(FINAL_RESULT) line in the function is printing the expected output in the output window. can any help me in this?? create ...