Top "Oracle10g" questions

Oracle is an RDBMS product.

Search for a particular string in Oracle clob column

How to get a particular string from a clob column? I have data as below which is stored in clob …

sql oracle oracle10g clob
ORA-00984: column not allowed here

I am doing a simple Oracle INSERT and I keep getting this error: [Err] ORA-00984: column not allowed here INSERT …

oracle oracle10g
Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it

When I do... Select TO_CHAR (date_field, 'Month DD, YYYY') from... I get the following: July 01, 2011 April 01, 2011 January 01, 2011 Why …

sql oracle oracle10g
Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup

I have made a desktop app Setup that connects with remote Oracle 10g Database. When I install Setup on remote …

c# oracle oracle10g oracleclient
Oracle "ORA-01008: not all variables bound" Error w/ Parameters

This is the first time I've dealt with Oracle, and I'm having a hard time understanding why I'm receiving this …

sql oracle plsql oracle10g
Execute Immediate within a stored procedure keeps giving insufficient priviliges error

Here is the definition of the stored procedure: CREATE OR REPLACE PROCEDURE usp_dropTable(schema VARCHAR, tblToDrop VARCHAR) IS BEGIN …

sql stored-procedures oracle10g privileges
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 …

sql oracle plsql oracle10g oracle11g
Oracle - Why does the leading zero of a number disappear when converting it TO_CHAR

In Oracle, when converting a number with a leading zero to a character, why does the leading number disappear? Is …

sql oracle oracle10g
What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors

We are running our Junit 4 test suite against Weblogic 9 in front of an Oracle 10 database (using Hudson as a continuous …

oracle junit oracle10g ora-12519
Oracle 10g: Extract data (select) from XML (CLOB Type)

I'm new in Oracle and I've - maybe trivial - a problem in a select. (I'm using Oracle 10g Express …

xml oracle oracle10g ora-00932