Tagged Questions
1
vote
1answer
38 views
Oracle error handling strategy [duplicate]
I am developing a project using oracle. I am writing functions and stored procedures to handle CRUD statements.
My question is in addition to oracle check constraints do i have to check error ...
6
votes
1answer
218 views
Package state not re-intialized on raise_application_error
When a package has state and the header is changed, the first call gets an error stack something like this:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of ...
7
votes
2answers
438 views
Does Oracle PL/SQL have a standard ASSERT routine?
I'd like to use an ASSERT routine functionally similar to the one found in other languages, i.e. a construct (be it a procedure, syntax...)
ASSERT( <condition>, <msg>)
such that when ...
0
votes
1answer
617 views
How to create custom error messages in APEX?
I would like to replace standard ORA-xxxxx messages with custom ones in Oracle Application Express. For example instead of this:
to have something like "You have left some fields blank, try again".
...
2
votes
0answers
610 views
ORA-01017: invalid username/password; logon denied
I've come across the abnormal situation, and can't understand what happens.
I am connecting databases using PL/SQL Developer 8.0.4.1514(I've also tried v7,but same) . Sometimes(When I am trying to ...
0
votes
2answers
93 views
ORACLE DB ERROR
We are currently experiencing a problem with Oracle DB 8. It is no longer starting and we get this message:
ERROR at line 1:
ORA-01113: file 19 needs media recovery
ORA-01110: data file 19:
...
3
votes
1answer
2k views
RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?
I have the following situation:
Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM.
I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
2
votes
1answer
654 views
ORA-01555: snapshot too old: rollback segment number with name “” too small
This error appears when I am trying to move LOB segment from one tablespace to another one.
Also during exporting the same error appears.
What can be a problem?
