Click here to Skip to main content
15,354,460 members
Home / Discussions / Database
   

Database

 
AnswerRe: script to delete related rows without cascade Pin
Mycroft Holmes25-Apr-14 13:16
professionalMycroft Holmes25-Apr-14 13:16 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens25-Apr-14 23:54
professionalNico Haegens25-Apr-14 23:54 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 0:33
professionalMycroft Holmes26-Apr-14 0:33 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 4:41
professionalNico Haegens26-Apr-14 4:41 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 13:46
professionalMycroft Holmes26-Apr-14 13:46 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 23:12
professionalNico Haegens26-Apr-14 23:12 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes27-Apr-14 12:44
professionalMycroft Holmes27-Apr-14 12:44 
QuestionExecute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8024-Apr-14 8:24
MemberUSAFHokie8024-Apr-14 8:24 
Hi. So I know I've done this before but I can't get it to work despite every example on the internet telling me it should... I'm trying to call a procedure from code. I keep getting an "Invalid SQL statement" exception. Any ideas why?

SQL
create procedure DoSomething
as
begin
 --does some calculations and updates some rows
end DoSomething;



I try to execute from code like so:

VB
Using conn = New OracleConnection(MyConnectionString)
   Using cmd = conn.CreateCommand()
      cmd.CommandType = CommandType.StoredProcedure 
      cmd.CommandText = "DoSomething"
      conn.Open()
      cmd.ExecuteNonQuery()
      conn.Close()
   End Using
End Using


At which point I get the aforementioned exception.

What am I doing wrong?

Sam.
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
MemberUSAFHokie8025-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
MemberUSAFHokie8025-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
MemberUSAFHokie8025-Apr-14 2:57 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:59
MemberUSAFHokie8025-Apr-14 2:59 
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
professionalSimon_Whale25-Apr-14 3:28 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 3:37
MemberUSAFHokie8025-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 

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.