Top "Oracle" questions

create oracle package encountered PLS-00103: Encountered the symbol "CREATE"

I am writing an oracle package using Oracle sql developer, I got this compile error: Error(7,1): PLS-00103: Encountered the symbol "…

oracle plsql pls-00103

TOAD for Oracle and Windows 7: Can't initialize OCI. Error -1

I have a problem with TOAD for Oracle 9.1 running on Windows 7 32-bit, described as follows: I have Oracle OraClient10g 10.0.2 …

oracle windows-7 32-bit toad

NLS_LANG setting for JDBC thin driver?

I am using the thin Oracle JDBC driver ver 10.2.0 (ojdbc14.jar). I would like to configure its NLS_LANG setting …

oracle jdbc nls ora-12705

ORA-00257:archiver error

When I try connecting to my database, I get the following error. ORA-00257:archiver error. Connect internal only until freed. …

oracle oracle9i ora-00257

Fatal error: Call to undefined function oci_connect()

I have the next lines uncommented (in my php.ini): extension=php_oracle.dll extension=php_oci8.dll And I …

php oracle iis oracle-call-interface instantclient

ORA-24338: Statement handle not executed

i'm using Delphi 7, Oracle 10, and ODAC Components. From the LoadTrainResult method I'm calling a storedProc. procedure TfrmTrain.LoadTrainResult; begin StoredProc.…

oracle delphi delphi-7 odac

Drop table from oracle database if table exist in sql statement

I have to use an SQL statement to drop a table, it will crash if the table doesn't exist. Is …

database oracle drop-table

Connecting to Oracle using Oracle.ManagedDataAccess

I am using Oracle.ManagedDataAccess Nuget Package Version 12.1.022 in my C# (.NET 4.0) project. The package automatically creates entries in the …

c# .net oracle odp.net

Getting Last Day of Previous Month in Oracle Function

I need a function in Oracle like this. When i giving a parameter a simple date. Then function should getting …

database oracle function date-arithmetic

Changing the data type of a column in Oracle

I created the following table CREATE TABLE PLACE( POSTCODE VARCHAR(10) PRIMARY KEY, STREET_NAME VARCHAR(10), COUNTY VARCHAR(10), CITY VARCHAR(10)); I …

oracle oracle10g oracle11g