Top "Oracle" questions

ORA-12519, TNS:no appropriate service handler found

I am closing the hibernate connection properly but i am getting this error after some clicks or after some page …

oracle hibernate session sessionfactory

Oracle EXECUTE IMMEDIATE with variable number of binds possible?

I need to use dynamic SQL execution on Oracle where I do not know the exact number of bind variables …

oracle plsql dynamic-sql

libclntsh.so.12.1 : cannot open shared object file error when running sample of node-oracledb

My goal is to connect to a oracle database on a VMWare guest machine (OpenSuse) from Ubuntu. For now I …

node.js oracle node-oracledb

Convert epoch to date in sqlplus / Oracle

I have the following table: SQL> desc recording Name Null? Type -------------------- -------- ------ CAPTUREID NOT NULL NUMBER(9) STARTDATE …

oracle datetime date sqlplus epoch

what is the difference between join keyword and inner join keyword in oracle sql?

I can't find documentations on the key word join but I saw examples on the web using it. I was …

sql oracle join inner-join

How to figure out the optimal fetch size for the select query

In JDBC the default fetch size is 10, but I guess that's not the best fetch size when I have a …

oracle memory jdbc fetch

Rename View in Oracle

Possible Duplicate: Rename Oracle Table or View I know you can use ALTER TABLE oldName RENAME TO newName; to rename …

sql oracle rename sql-view

Oracle Data Provider for .NET: Connection request timed out

We have a C# WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works …

c# oracle wcf timeout connection-timeout

Install sql loader linux

I tried to install Oracle instant client on a redhat machine. I have instantClient basic, sdk, and sqlplus but I …

oracle oracle11g sql-loader

PL/SQL Logging - How to control?

I am looking to introduce a logging framework into our existing Oracle application to replace the use of DBMS_OUTPUT. …

oracle plsql oracle10g instrumentation