Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Can someone explain ORA-29861 error in plain english and its possible cause?

I have an application implemented in Grails framework using underlying Hibernate. After it runs for a while, I got an …

oracle grails indexing
SQLException: Protocol Violation in oracle

I am getting the "Protocol Violation". I have an application running on RedHat Linux.The database and the application are …

java oracle jdbc oracle11g ojdbc
Calling Oracle stored procedures with MyBatis

I am in the process of moving our database over to Oracle from SQL Server 2008 but cannot get MyBatis to …

java oracle cursor ibatis mybatis
Cursor For Loop with dynamic SQL-Statement

Is there a way to perform a Cursor For Loop with an dynamic SQL-statement? If I don't want to declare …

oracle dynamic plsql database-cursor
Using Oracle PL/SQL table of record with multiple %rowtype fields

How can I populate a table of records which has more than one field of %rowtype using bulk collect? my …

oracle plsql record rowtype bulk-collect
Can I recover older Oracle pl/sql source code from a package body after i have replaced with newer code

I had created an Oracle PL/SQL package with a header and a body with lots of code. Later, I …

oracle replace package recover
Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c?

When I run this command in Oracle 12c SE2: impdp system/Oracle_1@pdborcl directory=DATA_PUMP_DIR dumpfile=mydb.dmp …

oracle import oracle12c datapump
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?

If you're halfway through a transaction and perform a DDL statement, such as truncating a table, then the transaction commits. …

sql oracle transactions ddl
measure time of an sql statement in a procedure in plsql

I must write a procedure which save the execute time of any sql-statement in a table. The procedure is calling …

oracle plsql procedure
ORA-01735: invalid ALTER TABLE option - Toad

When i execute below SQL in Toad its throws "ORA-01735: invalid ALTER TABLE option". ALTER TABLE CALCULATE ADD (CAL_METHOD …

sql oracle toad