The following shows the replication capabilities as described for ms sql server on oracle website. "the text inside the " " are my questions/confusion AGAINST what oracle website says" Please clear these points, what do you think? Is this article out of date? Replication functionality in Microsoft SQL Server or Sybase Adaptive Se...
I installed Oracle 10g Enterprise Editions onto Windows XP. It appeared that Partitions were installed as part of the default install, however the partitions functionality is not enabled. I can find instructions for enabling partitions on Unix/Linux, but not Windows. Has anybody had any success enabling partitions in 10g EE on their l...
It happened that all projects during the last 10 years were with Oracle as a database server. Now I'm starting on a side project on my own with MySQL (the latest stable). Are there any gotchas (things that do not work as expected by an Oracle user)? Anything to do with transaction management, locking, isolation levels, indexes, that ki...
Hi, I'm using hibernate with hbm2ddl.auto=update so that it'll automatically generate my oracle tables for me (i've no intention of learning oracle's sql). So far, so good, until now i'm trying to get it to create an index. As far as i can tell, i've made my annotations correctly: package data; import javax.persistence.*; import org.hi...
Hi I am trying to connect to oracle server from excel...i dont want to install oracle client in my system(presently there is no oracle client) So i am using Microsoft ODBC for Oracle Dim strConnection, conn, rs, strSQL strConnection = "Driver={Microsoft ODBC for Oracle};Server=ServerName;Uid=username;Pwd=password;" Set conn = Creat...
How to select all records,that may contain specific value that is known, without referring to specific column in SQL expression? For instance, i know,that some unknown column holds value 'xxx' and there are many columns and records in table. Thank you. ...
I am going to use Zend framework to access data from an oracle database. Previously I have the class I built to interact with the database (outside of framework), those are all procedural and function calls in the database (not SELECT statements), I have to bind variables and then execute them. I am looking to use Zend_db component to ac...
Hi, I'm new with EntityFramework. My application has a pool of context object instances (Each context has 1 connection to the DB). The problem is that when I update an object (and calling SaveChanges), the data is updated in the DB and in the updating context but when I select from other instance, it gets the old data of the selected ...
Hi, I have table with sequence and trigger so it creates new id when inserting it to the DB. How can I get the new object id, before calling SaveChanges()? I need this id for the links between the new object and other objects. I want to do it before calling SaveChanges because I want to have the option to rollback. Can someone solve...
Hello ! I want Oracle Data Integrator 10.1.3 to be able to connect to Active Directory running on a Windows 2003. I'm using SnpsLdapDriver but so far I'm dead unable to make it work. I keep getting error 52e : Insufficient Credentials. I tried every possible possible way I could - locking my account numerous times- and just nothing bu...
Oracle provides the APP_MULTI package (found in the APPCORE library) to support multi-selection of records in Oracle Forms. What must I do to my form in order to take advantage of this functionality? For example: Which triggers must I implement? Which APP_MULTI methods should I call and when? ...
this one isn't a dev question but silly tech quesiton... I had installed oracle 10g on my local windows box. When I open the Database Control window in IE it shows that listener is up but instance is down. I try to start it from there but it says wrong uname pwd. How can I start the instance or find my uname and pwd? Error: ERROR: O...
I have the below code in test.sql file. When there is a record in test_summary table everything works fine. But when there is no record inside the table it fails. I want it to continue to print the dbms_output message and process when there is no record. How can I do that? declare total_var number(20,2) := 0.0; nl_var ...
I am confronted with a 4-page SAS thing - macro? procedure? it has procedures within it, DATA blocks and PROC blocks, one PROC SQL block for importing from Oracle. Is there a tool that could translate SAS to something readable? Ideal would be SQL or PL/SQL (both seem applicable here), but almost anything procedural would be an improvem...
SELECT PRJ_CC_id , PROJECT_COSTCENTER_NAME , AREA_ID , AREA_Name , Activity_ID , Activity_Name , SUM(Total) FROM( ( SELECT PRJ_CC_id , PROJECT_COSTCENTER_NAME , AREA_ID , AREA_Name , Activity_ID , Activity_Name , (SUM(mon) + SUM(tue) + SUM(wed) + SUM(thu) + SUM(fri) + SUM(sat) + SUM( sun)) Total FR...
Hi, I have taken a sql dump as script from Jdeveloper and trying to create database at other place by running the oracle sql script through command line. When executing, at some place in the script, it is prompting for values like "Enter value for time:" and "Enter Value for p:" what could be the reason and how to prevent this when...
Deferred foreign keys are useful because Oracle checks the integrity of the foreign key constraint only on commit and not after each statement. Although this deferred integrity checking is very useful, sometimes I'd like to check the integrity without executing commit. Is it possible somehow? (Without changing the constraints to non-def...
Hi All Any help or suggestions would be greatly welcome on this. I've been developing a DotNet project on oracle (Ver 10.2) for the last couple of months and was using Varchar2 for my string data fields. This was fine and when navigating the project page refreshes were never more than a half second if even (it's quiet a data intensive p...
Hi, I'm using entity framework with oracle DB. I tried to use transaction scope (because I want the option to rollback): using (TransactionScope ts = new TransactionScope()) { ..... } The problem is that when I'm trying to query inside the using statement, an exception is thrown: "Unable to load DLL 'oramts.dll': The specified...
Hi all, Do any of you have any experience with using Oracle Text to search for content inside PDF files? I have a table, with a field called FILEDATA(blob). I would like to do the following query: SELECT id FROM ttc.contract_attachment WHERE CONTAINS(filedata, 'EXAMPLE') > 0; However, i'm not too sure about the type of index to add...