Oracle

send message to the java application

Oracle 10g with Windows platform.

How to give the privillege for triggers?

Hi,

ORA-00932: inconsistent datatypes: expected - got CLOB

SO : windows xp

utl_file open error

i have file in the unix path

comparing tables across databases sql refinement ideas required

Hi all

Oracle11g Patch issue

Hi all,I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AIX/oracle/Disk1/stage/Components/oracle.owb.rsf/11.1.0.7.0/1/Datafiles/filegroup16.jar.when I look into the

Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g

I am investigating how to run a Java stored procedure in multithread mode.I know that if I change the program to be multithreaded, the Database runs it fine, but it will not show any concurrency

C++ API to Oracle dB

I need to perform a select command to the Oracle dB to obtain information from a table.What libraries can I link into my project to make this work?I read about the OCI - but I cannot find any

ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128

Hi all,Oracle 10g. Linux.I'm facing the below error while trying to import a dumpfileIMP-00003: ORACLE error 604 encounteredORA-00604: error occurred at recursive SQL level 1ORA-01655: unable to

Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:

Hi All,I am trying to connect to the database server from the client server using ruby and facing the following issue-$ruby -r oci8 -e "OCI8.new('temp','temp','//host:1521/sid').exec('select count(1)

Export hangs

Hi all, please helpI have a Oracle 10.2.0.3.0 database. When I want to query the dba_segments or dba_directories views Oracle just hangs, and when I do a export that hangs aswell. I did a export

media recovery

Hi, i startup the database i got the errorSQL> startupORACLE instance started.Total System Global Area 146800640 bytesFixed Size 1286220 bytesVariable Size 79695796

DBCA Templates

Hi all,I'm working on creating a template for DBCA, but can't find any documentation on the parameters that one can use within the template. Obviously most are fairly obvious, but I'd like to see

Supress some serveroutput but not all

Hi,

How to form a xml form table with a single sql statement..?

Hi everyone,

AUTONUMBER PROBLEM

Hello Everyone,

Pass sql into pl/sql and create RMAN duplicate script.

Hi,

insert Multiple rows into the table from that table data

Hi All,

Getting number of affected rows in SQLPLUS..

Hi everyone,

How can I Compare two xml documents?

Hi all,