Top "Oracle10g" questions

Oracle is an RDBMS product.

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ORACLE 10g XE

Dont know what went wrong. It worked perfectly first time untill i restarted my Machine.

linux ubuntu oracle10g oracle-xe
JPA Entiy on synonym instead of table

I have a Seam 2.2 based Java EE 5 web application with a bunch of tables mapped to JPA 1.0 Entities via Hibernate 3.3.3. …

hibernate jpa oracle10g seam java-ee-5
ORA-22905: cannot access rows from a non-nested table item

CREATE OR REPLACE TYPE myObjectFormat AS OBJECT ( A VARCHAR2(200), B INTEGER, C INTEGER ) / CREATE OR REPLACE TYPE myTableType AS TABLE …

oracle oracle10g pipelined-function
Configuring Informatica Repository with Oracle 10g [Oracle not connecting]

Oracle Details:- Oracle 10g Enterprise Edition Host running XP x32 I use scott tiger for logging with SQL* Plus . …

oracle10g informatica-powercenter
How to Use COLLECT with VARCHAR2 Oracle 10g

I'm trying to get the COLLECT function to work for me. I'm using 10g and therefore found that LISTAGG and …

sql oracle10g collect listagg
Oracle 11g ORA-24247: network access denied by access control list (ACL)

I am using soap_api as in the link http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php. I was …

oracle oracle11g oracle10g ora-24247
EXECUTE_QUERY on MASTER-DETAIL form queries wrong block

I'm using Oracle Form Designer with a Master-Detail relationship, I have a WHEN-NEW-FORM-INSTANCE trigger which runs 'EXECUTE_QUERY;' but …

forms oracle oracle10g designer form-designer
Getting Stale Connection using OracleDataSource with OCI driver

I am getting stale connection error when there is no requests to the database from my java application for couple …

java jdbc oracle10g connection-pooling oracle-call-interface
Matching Oracle duplicate column values using Soundex, Jaro Winkler and Edit Distance (UTL_MATCH)

I am trying to find a reliable method for matching duplicate person records within the database. The data has some …

oracle plsql oracle10g data-quality
Recursive query for table dependencies is not recursing not as much as I'd like

I had an idea that I could write a query to find all the descendent tables of a root table, …

oracle recursion oracle10g recursive-query