Recently, We have migrated our Oracle 9.2.0.6 production database from Windows 32bit RAC (2 nodes) to Linux 64 bit environment. Linux 64 bit environment has 8 times more memory than Windows 32 bit environment and Linux 64 bit has faster disk ( RAID 10 compare to RAID 5 of windows). However, after this migration, we have noticed sql con...
I'm trying to update an oracle database so that it's schema matches a second database exactly. In doing so I've hosed something. I can't create or drop any object. create or replace procedure eag.test as begin null; end; Error: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist I get the...
I've got the syntax down but I'm wondering if somebody can provide an illustrative use case where database synonyms are very useful. ...
Hello guys! I have built a common app that works with PostgreSQL and should work on Oracle. However i'm getting strange errors when inserting records through a parametrized query. My formatted query looks like this: "INSERT INTO layer_mapping VALUES (@lm_id,@lm_layer_name,@lm_layer_file);" Unlike Npgsql which documents how to use th...
Hey I work in a big company and need to connect to a oracle database. It is set up so that i can connect to it through DSN, but I would like to connect to the db directly. How do i do that, when the only information I have is the name of the db and the username and password. It works fine through dsn. ...
Is there a way of finding the name of the server an Oracle database is hosted on from PL/SQL? ...
Hello friends i am running code given below which contains the setLogTimeEntery function and when this function is executed i am getting "Error : java.sql.SQLException: ORA-00917: missing comma" error and my database is oracle plese any one tell me wht is the problem. public int setLogTimeEntery(Connection con, LogTimeBean ltb) { i...
Dual table is used to select pseudo columns. it has one row and one column DUMMY which has a value X. I have two questions What actually does a pseudo column mean? How is the dual able to give the value for example: select sysdate from dual will result in current datetime. How is this possible? ...
I am using oracle database. i want to execute one query to check the data between two dates. NAME START_DATE ------------- ------------- Small Widget 15-JAN-10 04.25.32.000000 PM Product 1 17-JAN-10 04.31.32.000000 PM select * from <TABLENAME> where start_date BETWEEN '15-JAN-10' AND '17...
Hi all, I am using oracle 11g. I write code to connect oracle database with java 1.6, but I can't connect to it. When configure the guide line to below: I have ojdbc6.jar,orai18n.jar, and class12.jar. I set Class_Path: %ORACLE_HOME%\jlib\orai18n.jar;r;%Oracle_home%\jdbc\ojdbc6.jar After that I run sample java code connect to oracle...
Please suggest some Freeware both for Client and server side. This is to learn every thing about PL/SQL.. ...
Hi. I found that \Q\E doesn't work in oracle. What is the equivalent expression of \Q\E for oracle regex ? TIA ...
Friends, Hope you can help with a problem I am encountering with Apex and Web Services. I have used the wizard within Apex to to create a web service reference. The webservice works as expected however... One of the wizard steps requires the location of the wsdl file, which for development is at location a. However when application...
I'm new in the Oracle world, and i'm trying to make a insert from .NET (C#) using a parametrized query. My table is: CREATE TABLE layer_mapping ( lm_id NUMBER NOT NULL, lm_layer_name VARCHAR2(50) NOT NULL, lm_layer_file LONG RAW NOT NULL, CONSTRAINT lm_pk PRIMARY KEY(lm_id) ) "INSERT INTO layer_mapping VALUES (:lm_id,...
How to coalesce a table in oracle and What is it's syntax ? ...
I had a constraint in a table CREATE TABLE "USERSAPPLICATIONS" ( "USERID" NUMBER NOT NULL , "APPLICATIONNAME" VARCHAR2 (30) NOT NULL , CONSTRAINT "PK_USERSAPPLICATIONS" PRIMARY KEY ("USERID","APPLICATIONNAME") ) / Two weeks ago I modified the table, added some columns, deleted the constraint "PK_USERSAPPLICATIONS" and add...
I'm getting the same results from select length(column_name) from table as select dbms_lob.getlength(column_name) from table However, the answers to this question seem to favor using dbms_log.getlength(). Is there any benefit to using dbms_lob.getlength()? If it changes the answer, I know all of the blobs are .bmp images (nev...
I'm trying to obtain the Oracle package name used for a Crystal report data source using .NET code. I have obtained the procedure name, but for some reason I can not find the package name. Dim rpt as new ReportDocument rpt.Load(filename) Dim procedureName As String = rpt.Database.Tables.Item(0).Location Dim DataSou...
I am trying to call a PL/SQL block with ADO and VBA, but I can't pass input and/or output bind variables (probably aka parameters). dim cn as ADODB.connection ' ... open connection ... dim plsql as string plsql = "declare" plsql = plsql & " num_in number := ?;" plsql = plsql & " num_out number; " plsql = plsql & "begin" pls...
Hi, I'm creating a RESTful API which needs to access the database. I'm using Restish, Oracle, and SQLAlchemy. However, I'll try to frame my question as generically as possible, without taking Restish or other web APIs into account. I would like to be able to set a timeout for a connection executing a query. This is to ensure that lo...