Oracle Help

JDBC execute statement with Brackets - NullPointerException
Hi, I am trying to create Through JDBC Connection a Java Source Stored procedure. I get a Null Pointer Exception on Statement.executeUpdate() aused by: java.lang.NullPointerException at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.java:870) at oracle.jdbc.driver.T4CStatement.executeForRow... 22 Jan 2007 17:45

missing header creating XML doc from XMLDOM
Can anyone help me with this problem. I'm using Oracle 9i and SQL Developer 1.0.0.15.27. Here is some test code. CREATE OR REPLACE PROCEDURE TEST AS doc xmldom.DOMDocument; main_node xmldom.DOMNode; root_node xmldom.DOMNode; root_elmt xmldom.DOMElement; root_text xmldom.DOMText; root_name xmldom.DOMNode; ... 5 Dec 2006 16:30

problem with execute immediate and function
I have make the follow function: ______________________________________________ create or replace function replacedott2 return varchar2 as csql varchar2(2000); cursor cur_table is select table_name, column_name from all_tab_columns where owner = 'MARIANO' and data_type like '%CHAR%' AND table_name <> 'BIN$F... 15 Nov 2006 12:31

APEX in Oracle XE stopped working
We are running Oracle XE on Linux for prototyping a project and have been using the rather useful web based apex utility for minor administration and reporting jobs. It now seems to be broken and I cannot work out why. Usually we tap in the url http://machine.domain:8080/apex and the web interface starts but now... 21 Nov 2006 06:46

ORA-27101: shared memory realm does not exist
Hi, I installed OracleExpress on a windows 2003 server. Right after the installation, I was able to create and use a database. Then, after the first reboot, the database didn't start automatically, but after SQL> connect / SQL> startup things worked fine again. Now, after a third reboot, this trick... 2 Nov 2006 10:44

ORA-00600: internal error code, arguments: [17059]
Hello. When doing an insert via a stored procedure, I get the following errors: ORA-21000: error number argument to raise_application_error of -2 ORA-06512: at "PERFORCE.PKG_IMPORT", line 509 ORA-21000: error number argument to raise_application_error of -600 ORA-06512: at "PERFORCE.PKG_IMPORT", line 1124 ORA-... 31 Oct 2006 22:18

OCI :memory leak
Hi, Does someone knows what the parameters MalocFP, RalocFP, FreeFP really mean and have an example ? The Oracle official documentation is not very cleared on that subject. rc = OCIEnvCreate ( (OCIEnv **) &p_env, (CONST void *(*)(CONST void*,size_t))OCI_THREADED, ... 26 Oct 2006 11:01

ORA-13249
hi I have occured in this error ; SQL> SELECT/*+ INDEX (montane, mont_idx)*/ A.id id,B.id id FROM montane A,montan e B where SDO_NN (a.geom,b.geom,'sdo_num_res=1',1)='TRUE'; SELECT/*+ INDEX (montane, mont_idx)*/ A.id id,B.id id FROM montane A,montane B w here SDO_NN (a.geom,b.geom,'sdo_num_res=1',1)='TRUE' *... 4 Oct 2006 12:06

Strange ODBC error
Hello, I have made an ASP.NET application that connects to an Oracle database through ODBC. When I run the application in my development environment, it works fine, but when I run it in the customers test-environment, I get the following ODBC error message: ERROR [08001] [Microsoft][ODBC driver for Oracle][Ora... 24 Sep 2006 17:35

Urgent help needed!
Hi everyone, I have a project due in about an hour... one of the questions I have to answer is determining the physical size of the database. It's an Oracle 10 database. Actually, it's a small datawarehouse with 5 tables of raw data. I only have a SQL Plus interface, so some commands don't work. I can't find... 13 Sep 2006 23:51