oracle hierarcical sql group node

Advertisement
  • Error in Creating the Oracle Fail Safe Group during installation on MSCS

    Hi All, I am installing ECC 6 dual stack on MSCS. I have done steps till CI installation as per installation guide. I am gettig the following error in the step "Creating the Oracle fail safe group" while changing physical hostname into the virtu

    October 11

  • PL/SQL equivalent of T-SQL - "group function is not allowed here"

    Hi all, hope someone can give me a hand as I'm pretty stuck! I have been trying to convert some MS SQL Server T-SQL statements into Oracle PL/SQL and am stuck on the below one: SELECT CA.AssessmentID, (SELECT ProductName + ISNULL(' - ' + PrincipalBen

    October 11

  • Oracle.xml.sql.OracleXMLSQLException: Expected name instead of .

    Hi, I'm using XDK in Tomcat to execute queries and get the XML result in the browser. I have written many queries but now I'm having problems in one of them. The error output that I see in my browser is this one: <ROOT> <ERROR> oracle.xml.sql.

    November 30

  • Differences between being an Oracle and SQL DBA?

    Sorry to post this here, but I need so insight and don't know any Oracle DBA's. As posted here before, Ive been a MSSQL DBA for about 6 years and want to broaden my skill set. One of my ideas is to learn Oracle. For the record, I do realize that my t

    November 30

  • Oracle 8i vs Oracle 9/10: Group by and order of returned rows

    Hello people, I've searched the forum for threads on this topic: the order of returned rows in queries which have a GROUP BY clause, and found out that Oracle states that GROUP BY clause does not guarantee that the order of returned rows will be the

    November 30

  • Migrating from SQL Server to Oracle - Emulating SQL Server databases

    I want to offer Oracle connectivity from an ADO.NET application that was developed for SQL Server. The application accesses multiple databases, each having the same schema but each storing different data that is confidential to the users of each data

    November 30

  • SSMA 6.0 Oracle to SQL Server 2012 Migration

    Hi SSMA Team, We were migrating data from Oracle(Oracle 10.2.0.5.0)  to SQL server 2012 via SSMA 6.0 and during the migration experiencing  below error “ORA-03106: fatal two-task communication protocol error” We are using SSMA on Windows server 2008

    November 30

  • Change windows file permission from Oracle PL/SQL

    Hi I am using APEX4.2 to produce a graph ( by AnyChart) and used the simple pop up windows to save the graph to a PNG image file called test.png in the windows location ( being X:\APEX_CHART where X is pointing to windows server /abc/Transfer/APEX_CH

    November 30

  • Error while trying to call external  web service from oracle PL/SQL 10.2 g

    Hi I am trying to call an external web service from oracle PL/SQL .I am getting following run time error when I try to set the opeartion style. But as per the oracle documentation this is one of the 2 valid values. ORA-29532: Java call terminated by

    October 11

  • Need To Create a table in Sql Server and do some culculation into the table from Oracle and Sql

    Hello All, I'm moving a data from Oracle to Sql Server with ETL (80 tables with data) and i want to track the number of records that i moving on the daily basis , so i need to create a table in SQL Server, wilth 4 columns , Table name, OracleRowsCoun

    October 11

  • Matching data types b/w oracle and sql server

    anyone here knows if there is a list of data types supported by both oracle and sql server (regardless of releases & versions? an immediate response would be highly appreciated. thanks.Hi, The following post might be of assistance to you: http://msdn

    October 11

  • Unable to load Oracle XML SQL utility

    The following error appears for each java class, when we attempt to load Oracle XML sql utility into Oracle using the oraclexmlsqlload script: E.g. Error while resolving class OracleXMLStore ORA-00904: invalid column name Does anyone know why we woul

    October 11

  • Error in setting datasource location from oracle to sql server

    Post Author: jonathanaramburo CA Forum: Data Integration Hello, I have an application that uses a table named "events" which conflicts the sys.events view in master database in sql server. The error i was encountering is that, whenever i tried t

    October 11

  • Error Connecting to TFS 2013 from Oracle PL/SQL using MSSCCI

    Hi, previously we were able to connect to TFS 2008 through MSSCCI. we have MSSCCI 2013 provider, Teamexplorer 2013 andVersion Control Interface installed. While trying to connect to TFS 2013 from ORacle PL/SQL Developer 10.5 through MSSCCI ; there is

    October 11

  • Error: ORA-03113 while executing complex java code from Oracle PL/SQL

    Hi, I am trying to execute a complex java code from Oracle PL/SQL. The classes were resolved successfully. But in the middle of execution, I am getting the following error: ERROR: ORA-03114: not connected to ORACLE begin ERROR at line 1: ORA-03113: e

    October 11

  • Oracle.xml.sql.OracleXMLSQLException when using OracleXMLQuery getXMLDOM()

    Hi! I am trying to reuse a code in JDeveloper to get XML from a query. I have copied the code from a method and created a new method with the copied code and changed it. The problem is that when I run the old code I now get following error: Ett oförv

    October 11

  • [Oracle][ODBC SQL Server Driver][libssclient22]General network error

    I am using oracle gateway (11.1) for sqlserver on Linux platform with Oracle Server 10g. I am getting following error when i run any select query: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Oracle][ODBC SQL Serve

    October 11

  • Use of sql group function in orcl:query-database - urgent

    All, Version: 10.1.3.4 Two requirements for me: 1. I want to use sum function in orcl:query-database. How to use it? For ex: I tried the following <xsl:value-of select='orcl:query-database("select sum(salary) from emp",false(),false(),"j

    October 11

  • Error while converting schema from oracle to SQL server

    Hello, I am getting following error while converting schema from oracle to SQL server using SSMA. I get Errors 1-3 while migrating procedures and error 4 while migrating a table. 1- O2SS0050: Conversion of identifier 'SYSDATE' is not supported. 2- O2

    October 11

  • JS Validation for Drop down List is not working in Oracle PL/SQL Package

    Hi All, I am facing an issue with JavaScript validation done in Oracle PL SQL package. System Requirement: There is one screen which contains two fields viz. FLD 1 & FLD 2 and one 'Submit' button. FLD 1 and FLD 2 fields are drop down list boxes.These

    October 11