Hi, I get this exception only for SOME database update in my code after several days of application running. Some of the requests passed, and some of them (the same java code) fail. java.sql.SQLException: MaxOpenPreparedStatements limit reached at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:1...
In Oracle BI Publisher, I can't seem to find in what format the date parameters are passed in to the query. For example select * from myTable where the_date = :the_date Any ideas? ...
We have a oracle stored procedure that resides in oracle 10.2 database. The stored procedur contains certain inputs and outputs parameters. We are trying to create an asp.net webapplication to execute the stored procedure and bind the result that comes from the output paramerters into a gridview. But no luck. Here is what I have done so...
I was playing around with the DatabaseMetaData class to see how it works. The java doc comments seem to state one thing, while the code does a different. I know it is an interface, so it is really up to the vendor that supplied the JDBC driver to implement this correctly. But I was wondering if I am missing something or not? I am using...
Hi, I have a table, with abt 22 columns and 6-7 thousand rows in the following format Seq_num unique_id name ... ------------------------------------ 1 1 abc 1 1 cde 2 1 lmn 2 1 opq 3 1 pqr ...
char varchar varchar2 I understand that varchar2(10) will allocate space dynamically upto 10 bytes. char(10) will allocate 10 bytes at the beginning and fill it with junk if the actual datalength is less. If this is correct, what does varchar(10) do? ...
Hi, I have such oracle object: CREATE OR REPLACE type employee_obj AS object ( id NUMBER(10) , ... ) stored procedure function get_employee_obj () return employee_obj is l_employee employee_obj; begin ... return l_employee; end; and I need to call it from java code: ...
Hi Dim strConnection, conn, rs, strSQL, objCommand, param strConnection = "Driver={Oracle ODBC Driver};Data Source=DSNNAME;User Id=Username;Password=password;" Set conn = CreateObject("ADODB.Connection") conn.Open strConnection Dim cmdInsert As ADODB.Command Set cmdInsert = New ADODB.Command cmdInsert.ActiveConnection = conn cmdInsert....
I'm trying to improve performance of my Oracle SQL queries by using array binding to an OracleParameter. This is basically what I'm trying to do: List<string> IDValList = new List<string>(); IDValList.Add( "IDOne" ); IDValList.Add( "IDTwo" ); List<int> sizes = new List<i...
Why was the LONG RAW ORACLE column type deprecated in ORACLE 8 ? Did Oracle have issues with its implementation ? ...
In Oracle PL/SQL, you can always bind your code variables' type to a specific table.column type like this: myVar TABLE.COLUMN%TYPE So, if you change the column's type, you don't have to go over your code to re-define related var types (of course you'd still need to check you are properly using the variable). Is there a similar way to...
Hi everyone, I really hope would know how to do this cause I'm a total newbie to Blackberry development. Basically, I was asked to write a brief report on how a blackberry would access a DB server like Oracle, and I don't know how a blackberry works well enough to figure this out. I tried searches for blackberry DB on Google and I alway...
Can you tell me if this is done right or if I need to improve some of them I have a hard time understanding the query's when there is an associative entity. List all donors SELECT* from Donor; List the first and last names of all donors SELECT dfname, dlname FROM donor List the phone numbers of donors number 106 and 125 SEL...
Hi, I'm having trouble getting the correct query (oracle) for what I'm looking for. Essentially what I want is: SELECT count(ck.id) FROM claim_key ck WHERE (ck.dte_of_srvce > (SYSDATE - INTERVAL '30' DAY)) AND ck.clm_type = 5 AND ck.prgrm_id = 1 Explain: | Id | Operation | Name | Rows ...
Trying to generate an explain plan in SQL Developer, the program puts up a message box with title "failed to query plan_table" complaining "invalid column name". The plan is not generated or displayed. How to fix? ...
I understand a little about Oracle blocking - how updates block other updates till the transaction completes, how writers don't block readers etc. I understand the concept of pessimistic and optimisic locking, and the typical banking textbook examples about losing lost updates etc. I also understand the JDBC transaction isolation l...
I have been trying to figure this out for a little while now and I think it is time to ask for help.. I am building a schema provisioning script and I want to add some script output and error handling. The idea is that the script output window would only show me key messages without all the noise. Create Temporary Error Table Begin Tr...
I´m looking for one tool capable to analyse an existing db model (an Oracle schema in my setup) building a report with quality metrics, potential causes of problems (circular constraints, for example), etc. We have this kind of features for Java code using tools like PMD or checkstyle. Does anyone know about some tool like this for d...
Hello All, I'm wondering how safe or if it's even possible to have a website pull data from a Oracle database on a remote server? What and how big are the security issues with this? Thanks, Dane ...
Is there any easy way to save BLOB as a binary file into client-side file system with using of only standard Oracle utilities (such as sqlplus or sqlldr for example)? I've already looked onto UTL_FILE package, but actually I have two problems with it: I have doubts that it can work with client-side file system. I have no privilege to...