I have a php web application on web server connect with two oracle db server in loadbalance between them... we use in web application smarty template engine ..and ajax jquery the problem in - when more clients connect the web application the site stop or apache not running so we make restart to apache. - some web pages is slow. i want ...
I have created a VIEW using the CREATE OR REPLACE VIEW statement at the domain schema level. create or replace VIEW SERV as select loop.loop_serv serv, component.cmpnt_id,component.loop_id from component,loop where component.loop_id = loop.loop_id union select distinct ' ',0,0 from component,loop; So if I login to the domain schema a...
What's the limitation? Is there a specific volume of data each can handle regardless of disk space? When to use what assuming licensing is not a problem? ...
Are there are tangible benefits in changing the PLSQL_CODE_TYPE from interpreted to native? Was wondering if there are any case studies on the same. If benefit justifies the change, how can I go about implementing the same ? My platform is Windows 2003 server, running Oracle 10gR2 (10.2.0.1.0) if that helps. ...
In modern versions of Oracle, is there some "standard" (stored procedure, additional CREATE syntax, etc.) way to setting up a table with auto_increment/identity style column, or are we still stuck manually creating the table, creating the sequence, and creating the trigger. Update: I realize Oracle has no concept of an auto_increment. ...
Hello all, You've been excellent with my other questions previously - so here I am again, in need of some help! I've got a query which joins three tables and a strongly typed dataset which has the columns defined for everything which comes back from the query. When I go to fill the dataadapter, nothing gets filled. I've copied the co...
Background: We have a Webservice that is running under axis2 on a Tomcat. We would like our Oracle (10g Enterprise Edition Release 10.2.0.1.0) db to call our Webservice when a new row is entered into one of our tables. We've discovered we can use a trigger to call a Java Stored Procedure (JSP) or us PL/SQL and the UTL_DBWS utility. Neith...
A few months ago Oracle queries stopped working on our reporting services server after a service pack on the reporting server. I ended up having to grant permissions on Oracle directories to eliminate the first error and then renamed the NLS_LANG registry entry (effectively deleting it) to get rid of the second error. The old value was...
Hi, I'm building a small .NET Windows Forms application that talks to an Oracle database. I understand that I can use System.Data.OracleClient.dll to talk to Oracle, but it won't work without the Oracle Client installed. The Oracle Client is huge, is there any way I distribute my app (say in a zip file) without it being gigantic? i.e....
What is the proper way to define an oracle table who has an optional foreign key relationship with another table? For instance, some employee records have defined the country they are from (a FK from countries table), and some have not. ...
Is there a way to run an arbitrary sql script through ODP.NET? I'd like to do something like this: SomeOracleObject.RunFile("myfile.sql"); In other words, I want to obviate the need for sqlplus.exe. ...
I am new to oracle. I need to process large amount of data in stored proc. I am considering using Temporary tables. I am using connection pooling and the application is multi-threaded. Is there a way to create temporary tables in a way that different table instances are created for every call to the stored procedure, so that data from ...
I am trying to save unicode data (greek) in oracle database (10 g). I have created a simple table: I understand that NVARCHAR2 always uses UTF-16 encoding so it must be fine for all (human) languages. Then I am trying to insert a string in database. I have hardcoded the string ("How are you?" in Greek) in code. Then I try to get it b...
Hi, I'm dealing with two tables which have 2 columns, as listed under. Table 1: table_snapshot account_no | balance_due Table 2: table_ paid account_no | post_balance | delta_balance I added a third column to table2 with the following command: ALTER TABLE table_paid ADD delta_balance number(18); I'm trying to use the following que...
see also System.Data.OracleClient namespace discontinued? (Firstly don’t panic yet, System.Data.OracleClient is not being removed by Microsoft yet, however it is not in the client version of .net 4) This use to be possible by using System.Data.OracleClient, however Microsoft has decided to deprecate OracleClient. (OracleClient is the ...
Hello friends, I am changing my database from PostgreSQL to Oracle 11g. I am using hibernate 3.0 with Java and Struts. Everything is working fine with PostgreSQL. I have changed following in hibernate.cfg.xml file. <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="hibern...
I have a data file with 3 different sets of information like this below: @@@08016995BUILD 12/15/04POSITION "AABPX ","76826309","M","L"," 1509.4340" ----More similar Records_------------------------- @@@08016995BUILD 12/15/04SECDESC "AABPX ","mf","AMERICAN AADVANTAGE BALA","NCED PLAN AHEAD "," "...
What's the difference between using oracle's plus notation over the ansi standard 'join' notation? Is there a difference in performance? Is the plus notation deprecated? Thanks ...
his this is database admin I have a Jboss server with oracle database When I enter the Arabic fonts throung the application the database is not accepting throungh the application ; the arabic charters are also defined ; the operating system is Linux with oracle 10g and Jboss server with j2ee application ...
Hello, I've got a problem with JDBC. I'have the following code: //blargeparam is a blob column. PreparedStatement pst =connection.prepareStatement("update gcp_processparams_log set blargeparam= ? where idprocessparamslog=1"); pst.setBinaryStream(1,inputStream); I get the following error: Exception in thread "main" java.lang.Abstra...