Oracle

Using Python with Oracle Cursors
I'm trying to call a procedure from python (using cx_Oracle) but have no luck. I'm able to invoke arbitrary SQL and pass parameters etc, but getting an OUT cursor seems to be eluding me. Anyone know how to do this? I can pass in SQL to get the same results, but in general, we use a lot of OUT cursor procedures,... 7 Apr 2006 17:54

Oracle export error
Hi When I am doing a full export of database. I am getting the below error. EXP-00008: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel EXP-00008: ORACLE error 1041 encountered ORA-01041: internal error. hostdef extension doesn't exist EXP-00000: Export terminat... 9 Mar 2006 11:21

truncate /*+append*/
on 9ir2 say I have a table A and B. A contains 6 million records that need to be updated. This is in a data warehouse. I want to. truncate B. alter table B nologging insert /*+append*/ into B select < do update on A here>. I understand that this will generate some redo but will it generate any UNDO? ... 6 Mar 2006 19:16

Oracle Error: Cusor invalidated due to Parallel Execution
HI, I am running a query with 8 parallel threads. There is no DDl getting executed at that point in time. But still i am getting this error: ORA-12842: Cursor invalidated during parallel execution 2006-03-02:02:06:30 I am not sure why this error is coming. I am using Oracle 9i database with Linux operating sy... 2 Mar 2006 08:15

Oracle RAC 10g_r2: Oracle Notification Server Configuration Assistant - FAILED
Hi All: I am setting up a ORACLE 10g_r2 RAC solution. Environment Details: - 2 IBM x335 series - CentOs 4.2 - 2 GB RAM - 2 X 36 GB SCSI - Intel Xeon 3.066 GHz I am stuck on the configuration of the Oracle Clusterware Configuration. I have double checked all of my steps and have retried this installer 3... 15 Mar 2006 15:25

Intermittend ORA-12519, TNS:no appropriate service handler found
Hi all, we have an Oracle 10 (version details below) on Linux (RHEL 4). When connecting via JDBC we get intermittend ORA-12519 (reflected as TNS-12519 in listener.log). sqlldr also has a problem, although at the moment I can't exactly determine whether it's the same (I'm guessing it is because the happen abo... 27 Feb 2006 13:25

Oracle MERGE to remote DB with ORA-01008: not all variables bound
Hi, I am trying to merge a table in a remote database via DBLINK, but I got an error: in the using() part, I use a subquery from local db tables. The simple table merge (between tables with the same structure, and no subquery in using part) is fine. ORA-01008: not all variables bound ORA-02063: preceding lin... 11 Jan 2006 16:08

Instant Client ODBC
I'm running Windows XP and want to connect MS Access to a remote Oracle 10g database. I have installed Instant Client 10.2.0.1.0 and the ODBC package. The ODBC package includes odbc_install.exe. When I run that file I get an error message "Could't find Oracle Instant Client in present directory." I have the directo... 9 Jan 2006 06:53

ORA-01654 Fix?
I am being told to create another tablespace for an error that I have been getting (ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in tablespace SYSTEM ORA-27039: create file failed, file size limit reached OSD-02067: illegal option specified ORA-27039: create fil). I am trying to understand... 22 Dec 2005 19:19

FRM-40508: Oracle error: unable to insert record
Hi, When I try to insert data in the Forms, appears the error FRM-40508: Oracle error: unable to insert record and automatically return to the logon page. I have a security table with different users, all of then have the same problem. Desc Seguridad; Name ... 15 Nov 2005 15:18