Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
trigger script
- Thread starter filipe26
- Start date
SantaMufasa
Technical User
Filipe,
Unfortunately, Oracle error "ORA-03113-End of file on comunication channel" means simply that the connection between your client session and your server session became disconnected. This can occur for dozens of reasons, from the network going down to Oracle simply becoming confused about your connection.
If you receive this error over and over while attempting to run the same code, but you do not receive the same error for virtually identical code, then we need to investigate apparent differences between the working and non-working scenarios.
So, the first question is, "Do you receive this error over and over for this same code?"
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
Unfortunately, Oracle error "ORA-03113-End of file on comunication channel" means simply that the connection between your client session and your server session became disconnected. This can occur for dozens of reasons, from the network going down to Oracle simply becoming confused about your connection.
If you receive this error over and over while attempting to run the same code, but you do not receive the same error for virtually identical code, then we need to investigate apparent differences between the working and non-working scenarios.
So, the first question is, "Do you receive this error over and over for this same code?"
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Thread starter
- #3
it seems that it is a bug from pl/sql because i made a singular drop of all tables and i ran the script again and it works.Now i have another problem:
I have a field of a table and i want to restrict the options choice from a view.By another words,a field with a view lookup.
I have a field of a table and i want to restrict the options choice from a view.By another words,a field with a view lookup.
SantaMufasa
Technical User
Filipe,
I am pleased that you resolved your first problem.
For you new problem, I propose creating a new thread entitled, "Restricting field options to View lookup." Also, in that thread, please disclose
1) application you are using for this activity...Is it SQL*Plus, Oracle*Forms, some other?
2) sample code you anticipate to use the View lookup.
3) sample data in the lookup view.
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
I am pleased that you resolved your first problem.
For you new problem, I propose creating a new thread entitled, "Restricting field options to View lookup." Also, in that thread, please disclose
1) application you are using for this activity...Is it SQL*Plus, Oracle*Forms, some other?
2) sample code you anticipate to use the View lookup.
3) sample data in the lookup view.
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Status