I'm trying to convert some xml data coming from a CLOB to a XMLType column. The XML have some accentuated characters as values (documents are written in french). Here is what the instruction looks like : insert into mytable (id, xmldata) values (p_id, xmltype(p_xmldata)); p_id and p_xmldata are variables previously extracted from th...
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? ...
I have a C#.Net application that accesses data from a commercial application backed by an Oracle 10 db. A couple of fields in the commercial app's database (declared as varchar2(n)) contain special characters. The "smart quote" apostrophe, for example. The commercial client app displays these characters correctly, but my application i...
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'm using Oracle 11g for my database and its Oracle Streams AQ feature as JMS implementation. For all I know, it should be possible to implement a Spring based message-driven POJO (MDP) that uses the same data source for both transactional data access and JMS transactions -- all without XA-Transactions (IIRC, this was marketed as a feat...
Hello all, I have been developing simple web services and clients using JBoss but now I need to deploy a web service in Oracle Enterprise Manager. I tried deploying a test web service but an axis error shows when I try to access it, saying the axis version number is wrong. I have also noticed that my web service doesn't show under "We...
Hi there, i just have some issues regarding the usage of the latest oracle ODP.NET client , and using it to connect with ASP.NET 2008 and C# to an old Oracle 9i database. As stated in the ODP.NET instalation instructuins it should work, but i'm a litte bit rusty when it comes to configure oracle. The old 9i client has issues for .NET, it...
A recent project called for importing data into an Oracle database. The program that will do this is a C# .Net 3.5 app and I'm using the Oracle.DataAccess connection library to handle the actual inserting. I ran into a problem where I'd receive this error message when inserting a particular field: ORA-12899 Value too large for column ...
Im having an issue at the moment where my testing environment is not persisting the trademark character "™" in the database. When I enter in the form data, then submit it, I can see that on the server side, the request has the correctly encoded ™ character, but then when the call to hibernate's "saveOrUpdate()" method is called, the data...
Hi folks, I've written a query to collect some data to display in an auto-updating box & whisker graph in excel. I'd like to use rollup to create summary rows for each type of train_line (PF and MJ) to include in the excel chart. Can I do that using Rollup? I've tried to get my head around Rollup, but I'm not getting far. I've tried...
What is sql Loader...in details... ...
I want to use subsonic in combination with an oracle database. I just can't find the template needed to generate the code. In the TemplateProviders a provider for oracle is missing. Does anyone have an implementation for this. Thanks in advance. ...
Consider the tables.. TABLE_1 OPTION VARCHAR2 (2), NAME VARCHAR2 (50), SQLSOURCE VARCAHR2(400) TABLE_2 USER_NAME VARCHAR2 (50), USER_ID NUMBER (10) DEPT_ID NUMBER (10) This is the update stmt.. UPDATE table1 SET OPTION='K', SQLSOURCE='SELECT DEPT_ID FROM TABLE_2 USER_ID= 15 ORDER BY USER_NAME' WHERE NAME='GURU' Its working fine, ...
How do I convert hexadecimal to decimal (and back again) using Oracle SQL? ...
Hi, I would like to know whether there are any tools which convert xml data into Oracle tables. I came across Altova's MapForce. But I am not sure whether I could use that for achieving this. Could someone suggest any other alternate option / or any help documentation of Mapforce which talks about this conversion. Thanks, Shafi ...
I have a strange situation. I have to use NVL(columna, columnb) in Oracle and MySQL. I can't change the SQL as it is in a package I can't edit but it is the only thing that doesn't work in the application I have between MySQL and Oracle. How would I write NVL() in MySQL. I've looked here (http://dev.mysql.com/doc/refman/5.0/en/create-fu...
I want to execute the oracle's import utility in MSBuild as a task. Please give a detailed answer. I am a beginner. ...
I wish to create some views using SQL*Plus via script, but seem to hit a problem if a developer has placed a blank line mid statement. The following statement works fine in TOAD / PL/SQL developer etc, but fails in SQL*Plus. (This is usually scripted, but entering it manually gives exactly the same error) Can anyone tell me why / how ...
We have an application that used the C++ zApp framework for UI (forms, fonts, everything). We have slowly converted it to use the .net framework and recently found that Greek characters are no longer displaying correctly. In one version of the application I have a C# .net form and a C++ zApp form that both display the same data. The p...
Hi all, I'm trying to compare an MD5 checksum generated by PHP to one generated by Oracle 10g. However it seems I'm comparing apples to oranges. Here's what I did to test the comparison: //md5 tests //php md5 print md5('testingthemd5function'); print '<br/><br/>'; //oracle md5 $md5query = "select md5hash('testingthemd5fun...