Top "Oracle10g" questions

Oracle is an RDBMS product.

ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g …

oracle oracle10g odp.net oracleexception
PL/SQL block problem: No data found error

SET SERVEROUTPUT ON DECLARE v_student_id NUMBER := &sv_student_id; v_section_id NUMBER := 89; v_final_grade NUMBER; …

sql oracle plsql oracle10g ora-01403
How to count the number of occurrences of a character in an Oracle varchar value?

How can I count number of occurrences of the character - in a varchar2 string? Example: select XXX('123-345…

sql oracle count oracle10g
Best way to reset an Oracle sequence to the next value in an existing column?

For some reason, people in the past have inserted data without using sequence.NEXTVAL. So when I go to use …

sql oracle oracle10g primary-key sequence
Oracle Trigger ORA-04098: trigger is invalid and failed re-validation

I am trying to create a simple trigger in an oracle 10g database. This script to Create the trigger runs …

sql oracle oracle10g ora-04098
Disabling contextual LOB creation as createClob() method threw error

I am using Hibernate 3.5.6 with Oracle 10g. I am seeing the below exception during initialization but the application itself is …

java hibernate oracle10g clob
How to View Oracle Stored Procedure using SQLPlus?

How can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc …

oracle stored-procedures oracle10g sqlplus
How to get input from user at runtime

I want to take runtime input from user in Oracle 10g PL/SQL blocks (i.e. interactive communication with user). …

oracle oracle10g user-input
How to increase dbms_output buffer?

I tried to debug my dynamic query via dbms_output but seems like the query string is too long for …

sql oracle plsql oracle10g dbms-output
Create an Oracle function that returns a table

I'm trying to create a function in package that returns a table. I hope to call the function once in …

plsql oracle10g package