After sending a simple query via OCCI (example: select * from ALL_USERS) I'm in the need to know the datatype for the column, for the moment I've been playing with the ResultSet::getColumnListMetaData() method without success. Questions: 1. How can I get the datatype by using the aforementioned method and the MetaData class? 2. Is ...
For a pair of cursors where the total number of rows in the resultset is required immediately after the first FETCH, ( after some trial-and-error ) I came up with the query below SELECT col_a, col_b, col_c, COUNT(*) OVER( PARTITION BY 1 ) AS rows_in_result FROM myTable JOIN theirTable ON myTable.col_a = theirTable.col_z GROUP BY ...
I'm working with a legacy application that uses OleDB to connect to an Oracle10g database. One customer is getting these exceptions being reported quite often: System.Data.OleDb.OleDbException: ?~¿????x(?(?? at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data...
Dear members, As you know Sun/Glassfish has been captured by the Oracle and Oracle has commercial approach. So, what do you think for the future of Open-Source Glassfish and/or Netbeans IDE? Is this better choice to migrate to eclipse/Jboss or not yet? Regards ...
Hi Can we connect from excel (excel-VBA) to oracle(in a remote server) without installing oracle client in the client system... I tried all the options below but it is throwing error as oracle client should be installed. below is the connectionstring i have used 1)strConnection = "Provider=OraOLEDB.Oracle;Data Source=SourceName;User I...
hello, i have an error with my hibernate request Hibernate operation: could not execute query; bad SQL grammar [select tarifs0_.D_ANNE as D1_33_, tarifs0_.D_NZONE as D2_33_, tarifs0_.D_CTYPE_LOCAL as D3_33_, tarifs0_.D_NTARIF_NORMAL as D4_33_, tarifs0_.D_NTARIF_REDUIT as D5_33_, tarifs0_.D_NSURFACEMIN as D6_3...
I have a query like this: SELECT X.Y( 'p1', 'p2', 'p3', 'p4', '100') from dual I know what dual is but this part X.Y( 'p1', 'p2', 'p3', 'p4', '100') really makes me wonder. What does this syntaxis mean? Are X and Y tables or what? ...
Hello, i have the following Oracle table: GAMES id_game int id_user int dt_game DATE Before creating a new record i must check that the same user has not inserted a game more that N times a day. I'm actually selecting the number of games played today in this way: select count(1) as num from GAMES where id_user=ID_US...
I'm debating whether to re-write my INFORMIX-SQL app with I4GL (character-based) or another Windows/GUI-based tool. I want to know specific instances of limitations, bugs or drawbacks of using another development tool before I invest considerable amount of time evaling another product. Answers to this question could save me a lot of tim...
Im new to cursors in Oracle. I have a piece of SQL that is contained in a variable. I want to open a cursor with this sql. How do I do this? Seems simple but all the examples I find just have the sql typed directly below the "open cursor_name for" statement. Here is what I would like to run (assume I have variable v_sql with my sql quer...
I have this error when running a large query on oracle. any advice? I'm using pl sql version 10.2 I have noticed that the error is due to creating a view that is based up on many tables, and when I do a select from this view to a specific parameter with a where condition I got that error. When I checked the logs I found out this o...
Hello Friends, I have two tables Users (Userid, Name, PhoneNumber) Applications (ApplicationsId,UserId, ApplicationName, ActiveDate) Every user will have more than 1 application. In Nhibernate using lazy loading I can get the users data along with all the applications for every user. So, I used to do something like user.applications...
I want to have two auto_increment column's per table, but mysql allows only one auto_increment columns. So, I tried replicating the oracle sequence using my own table. Here is the schema. create table logical_id_seq ( logical_id int auto_increment, primary key(logical_id) ); create table mytable ( physical_id int auto_incr...
I have some small python apps that use cx_Oracle to connect to an Oracle database. I deploy these apps by compiling them with py2exe, which works fine in many cases. The problem is, there is no standard Oracle Client version (9i and 10g for example) across the many people who need to install this, and it would be very frustrating to try...
I have a 400 line sql query which is throwing exception withing 30 seconds ORA-03113: end-of-file on communication channel Below are things to note: I have set the timeout as 10 mins There is one last condition when removed resolves this error. This error came only recently when I analyzed indexes. The troubling condition is ...
my spring-hibernate application run without problem for the past 1 week, but suddenly i get below error. will this caused by configuration error in applicationContext.xml? there is no error on my oracle10g log files (i get below errror every 1-2weeks once) 28 Jul 2010 14:20:19,177 INFO [http-2020-19] - Loading XML bean definitions from...
Heyho, I've gotta write a Procedure which Inserts a resultset from a select-statement into a table. A co-worker of mine did something similar before to copy values from one table to another. His statement looks like this: CREATE OR REPLACE PROCEDURE Co-Worker( pId IN INT ) AS BEGIN INSERT INTO Table1_PROCESSED SELECT * FROM...
Heyho, I'm trying to set a Procedure like: Create or Replace Procedure MyProcedure1( x in number default 1, y in number default 1 ) AS Begin If x = 1 then MyProcedure2; EndIf; If y = 1 then MyProcedure3 EndIf; End MyProcedure1; MyProcedure3 must be done after MyProcedure2 is completely done, because it needs some values which are set...
I'm working on a problem in Oracle that I'm struggling to solve 'elegantly'. I have a data extract with three different identifiers: A, B, C Each identifier may appear in more than one row, and each row may have one or more of these three identifiers (i.e the column is populated or null). I want to be able to group all records that ...
I am trying to sum INTERVAL. E.g. SELECT SUM(TIMESTAMP1 - TIMESTAMP2) FROM DUAL Is it possible to write a query that would work both on Oracle and SQL Server? If so, how? Edit: changed DATE to INTERVAL ...