I am getting this error message in Internet Explorer with Oracle 10g installed on Vista: The 'oraoledb.oracle.1' provider is not registered on the local machine I can connect to Oracle databases OK with SQL Server 2008 as a linked database. However, my IE 7 doesn't see it. I have installed it as administrator and tried many different ...
Hi all, I've been connecting to an oracle 10g server using ms sql servers linked server feature and for some reason i am unable to use the with clause. Does this clause only work in in the pl/sql console or is there something i can do to make it work with linked servers as well? The error i am getting is Msg 7357, Level 16, State 2, ...
I'm trying to group data from the following three tables to create a new table. the account_no fields in bmf and acct_map are actually drawn from cmf. Fields: bmf: account_no, trans_date cmf: account_no, balance_due acct_map: account_no, external_id The fields I want in my new table are : external_id, account_no, balance_due When...
I was finally able to get the schema correct on both sides. Im ready to run the final step and.... Data migration started.... Data migration failed... System.Data.OracleClient requires Oracle client software version 8.1.7 se I have done ever suggestion on google known to man 1) install oracle client 10.2 and remove 10.1 2) add "authent...
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...
Has anyone heard whether Oracle will support the 10G client Windows 7? I am forced (very unwilling since I started out on SQL Server) to deal with Oracle dev every day and since 7 is "just a polished Vista" (I feel it is far superior and I've been using Vista since RTM) the theory is that it will work fine. Also, if this is the wrong pl...
We're trying to figure out the best way to handle BULK INSERTs using Oracle (10gR2), and I'm finding that it can be a pretty complicated subject. One method that I've found involves using the Append optimizer hint: INSERT /*+ Append*/ INTO some_table (a, b) VALUES (1, 2) My understanding is that this will tell Oracle to ignore indexe...
I need to get NHibernate 2.1 to talk to an oracle database. I am being required to use the Orace 10g client. I get the following error when trying to build my session factory: Unable to cast object of type 'Oracle.DataAccess.Client.OracleConnection' to type 'System.Data.Common.DbConnection'. I don't recall getting this error ...
I have this method to insert data using jdbc that will insert the value according to the java type. Something like this: Object o = map.get( key ); if( o == null ) { // setNull( index ); } else if( o instanceof String ) { // setString( index, (String) o ); } else if( o instanceof Timestamp ) { // setTimestampt( index, ( Ti...
Here is my table MYTABLE(ID NUMBER(10), DATATYPE VARCHAR2(2 BYTE), XMLDATA LONG ) Note1: I cannot alter this table Note2: I'm using Oracle 10g Here is a sample of XMLDATA <myxml version="1"> <node1> <child1>value to get</child1> </node1> </myxml> I tried xmltype() but it's not working with a LONG type (ORA-0...
there is a table== create table newstudent(enroll int, name varchar2(20), DoJoin date); in c# when i type oraclecommand(1,'amit purohit', DateTime.Now()); //Error found 'nvalid month' oraclecommand(1,'amit purohit', String.Format("{0:dd-MMM-yyyy}")); //problme that save only date into database but i need time also. like '11-AUG-2009 11:...
Hi I have just scheduled an html AWR report, but I cannot seem to find the output on the database server, can somebody tell me in which directory does the report created? ...
What is an XMLTABLE. Do let me know the syntax of creating an XMLTABLE Sample query to fetch records from XMLTABLE. Are there any database level pre-requisites required before creating an XMLTABLE. ...
I asked this question in regard to SQL Server, but what's the answer for an Oracle environment (10g)? If I have a table containing schedule information that implies particular dates, is there a SQL statement that can be written to convert that information into actual rows, using something like MSSQL's Commom Table Expressions, perhaps? ...
I have a table with one column " otname " table1.otname contains multiple rows of alpha-numeric string resembling the following data sample: 11.10.32.12.U.A.F.3.2.21.249.1 2001.1.1003.8281.A.LE.P.P 2010.1.1003.8261.A.LE.B.B I want to read the fourth number in every string ( part of the string in bold ) and write a query in Oracle 10g...
Hi, I have a sample xml file created using Editplus( in windows). < ?xml version="1.0" encoding="UTF-8" ?> < badges > < row UserId="3714" Name="Teacher" Date="2008-09-15T08:55:03.923"/> < row UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957"/> < / badges> My goal here is to get this information into Oracle DB...
Friends, I am looking to introduce a logging framework into our existing Oracle application to replace the use of DBMS_OUTPUT. The framework will be used primarly to aid debugging and would detail such things as starting x procedure, details of parameters, ending procedure x etc. It should also have the functionality to be turned on ...
I've two tables with the following fields: table1 : OTNAME table2 : SNCODE, description_text I'm trying to add the two columns of table2 to table1 and update the columns. My query is: alter table table1 add sncode integer alter table table1 add description_text varchar2(30) update table1 set snc...
e.g. select * from v_schema || '.tbl_a@' || abc.world ...