Top "Oracle" questions

OracleMTSRecoveryService failed to start?

i am getting this error while starting OracleMTSRecoveryService : Could not start the OracleMTSRecoveryService service on Local Computer. Error 1: Incorrect function.* …

.net oracle odac

What could cause an ORA-00936 - Missing Expression with the following sql?

We're seeing the error message ORA-00936 Missing Expression for the following SQL: Note that this is just a cut-down version …

sql oracle ora-00936

Add Day to Timestamp

How do I add days to a timestamp? If my timestamp is 01-JAN-2011 11-09-05 and I add 2 days, I …

sql oracle timestamp date-arithmetic

Determining the NLS_LANG setting for an existing Oracle database dump file

We were handed a dump file by another team who are gone away for the rest of the year. When …

oracle import dump nls-lang

Oracle - How do I get the actual size of a specific ROW?

Is this possible? Or at least I'm looking to have a list of the size of all rows in a …

oracle size row

Can I execute a procedure with default null parameters?

I recently created a procedure that is defined like this: create or replace PACKAGE pkg_dml_legal_transactions AS PROCEDURE …

oracle plsql procedure

Missing artifact com.oracle:ojdbc14:jar:10.2.0.1.0

I am trying to add dependency for ojdbc14 in pom.xml. Steps I followed for adding ojdbc14.jar in local …

java eclipse oracle maven ojdbc

How do I create a Database Link where remote and local are the same server

I have a need to create a database link that is a link to a schema on the same server. …

oracle database-link

what is oradiag_<user> folder?

I see these in the my Linux folder hierarchy after installing the Zend Framework. /oradiag_root/ /user/myuser/oradiag_myuser/ /…

oracle debian zend-server

What is the default size of a varchar2 input to Oracle stored procedure, and can it be changed?

I have a stored procedure in Oracle Database 10g where my input is a varchar2 but I'm having issues getting …

oracle stored-procedures varchar2