Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
QuestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
ZurdoDev24-Apr-14 10:33
professionalZurdoDev24-Apr-14 10:33 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 1:21
USAFHokie8025-Apr-14 1:21 
SuggestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
ZurdoDev25-Apr-14 1:27
professionalZurdoDev25-Apr-14 1:27 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 2:15
professionalthatraja25-Apr-14 2:15 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:32
USAFHokie8025-Apr-14 2:32 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 2:48
professionalthatraja25-Apr-14 2:48 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:57
USAFHokie8025-Apr-14 2:57 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:59
USAFHokie8025-Apr-14 2:59 
Here is the actual code, though I can't imagine why this would help:

SQL
create or replace
procedure UpdateUnitType as
--updates unit type codes
  cnt number(10,0):=0;

begin
 
  for u in (select * from unit where type_cd = 1)
  loop
  
    cnt := 0;
  
    select count(billet_id)
    into cnt
    from billet
    where fiscal_year = u.fiscal_year
    and uic = u.uic;      
    
    if cnt > 0 then
    
      update unit
      set type_cd = 2
      where unit_id = u.unit_id;
    
    end if;
      
  end loop;

end updateunittype;

GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 4:29
professionalthatraja25-Apr-14 4:29 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
Simon_Whale25-Apr-14 3:28
Simon_Whale25-Apr-14 3:28 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 3:37
USAFHokie8025-Apr-14 3:37 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
Jörgen Andersson25-Apr-14 3:23
professionalJörgen Andersson25-Apr-14 3:23 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut25-Apr-14 3:32
professionalGuyThiebaut25-Apr-14 3:32 
QuestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut29-Apr-14 4:21
professionalGuyThiebaut29-Apr-14 4:21 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja29-Apr-14 23:30
professionalthatraja29-Apr-14 23:30 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut30-Apr-14 2:26
professionalGuyThiebaut30-Apr-14 2:26 
QuestionHow many types of lock exist in Sql server Pin
Tridip Bhattacharjee23-Apr-14 20:59
professionalTridip Bhattacharjee23-Apr-14 20:59 
AnswerRe: How many types of lock exist in Sql server Pin
Eddy Vluggen23-Apr-14 21:40
professionalEddy Vluggen23-Apr-14 21:40 
AnswerRe: How many types of lock exist in Sql server Pin
Corporal Agarn24-Apr-14 9:42
professionalCorporal Agarn24-Apr-14 9:42 
Questionconverter Pin
Member 1074305623-Apr-14 10:26
Member 1074305623-Apr-14 10:26 
AnswerRe: converter Pin
Mycroft Holmes23-Apr-14 12:49
professionalMycroft Holmes23-Apr-14 12:49 
QuestionINNER JOIN Pin
Syafiqah Zahirah23-Apr-14 8:26
Syafiqah Zahirah23-Apr-14 8:26 
AnswerRe: INNER JOIN Pin
Eddy Vluggen23-Apr-14 11:25
professionalEddy Vluggen23-Apr-14 11:25 
AnswerRe: INNER JOIN Pin
Andrius Leonavicius23-Apr-14 13:11
professionalAndrius Leonavicius23-Apr-14 13:11 
QuestionSQL statement Pin
Syafiqah Zahirah23-Apr-14 6:47
Syafiqah Zahirah23-Apr-14 6:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.