Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
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 
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 
With these sorts of issues the first thing I do is write a really simple stored procedure to eliminate the stored procedure being an error.
Now I know you have tested the stored procedure from Oracle however I would do this anyway.

So create something like :

SQL
create procedure test_orac as
begin

declare @testvar int
select @testvar = 1

end


Then call this procedure from .NET .
If you still get the same error check your tnsnames.ora file to be sure that it points to the correct service and that the syntax within that file is correct.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

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 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 6:56
mvePIEBALDconsult23-Apr-14 6:56 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:00
Syafiqah Zahirah23-Apr-14 7:00 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 7:19
mvePIEBALDconsult23-Apr-14 7:19 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:25
Syafiqah Zahirah23-Apr-14 7:25 
AnswerRe: SQL statement Pin
Eddy Vluggen23-Apr-14 6:57
professionalEddy Vluggen23-Apr-14 6:57 

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.