P
Problematic coder
The intention is to call a stored proceedure which sets flags in the
database, this requires no parameters and the page does not need an
output from the stored proceedure, though is this is necessary I could
change that.
Here is the code I am using:
Dim objcom2 = New Data.OracleClient.OracleCommand
With objcom2
.Connection = objcnn
.CommandTimeout = 60
.CommandType = Data.CommandType.StoredProcedure
.CommandText = "MYPROC"
End With
objcom2.ExecuteNonQuery()
Here is the error I get:
System.Data.OracleClient.OracleException was caught
ErrorCode=-2146232008
Message="ORA-06550: line 1, column 7:
PLS-00201: identifier 'MYPROC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
Source="Microsoft.VisualBasic"
StackTrace:
at
Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags
Flags)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container
BaseReference, String MethodName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags
InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object
Instance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean
IgnoreReturn)
at internal_processing.btnSubmit_Click(Object sender, EventArgs
e) in C:\Documents and Settings\uid\My Documents\Visual Studio
2005\WebSites\.......:line 350
database, this requires no parameters and the page does not need an
output from the stored proceedure, though is this is necessary I could
change that.
Here is the code I am using:
Dim objcom2 = New Data.OracleClient.OracleCommand
With objcom2
.Connection = objcnn
.CommandTimeout = 60
.CommandType = Data.CommandType.StoredProcedure
.CommandText = "MYPROC"
End With
objcom2.ExecuteNonQuery()
Here is the error I get:
System.Data.OracleClient.OracleException was caught
ErrorCode=-2146232008
Message="ORA-06550: line 1, column 7:
PLS-00201: identifier 'MYPROC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
Source="Microsoft.VisualBasic"
StackTrace:
at
Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags
Flags)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container
BaseReference, String MethodName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags
InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure)
at
Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object
Instance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean
IgnoreReturn)
at internal_processing.btnSubmit_Click(Object sender, EventArgs
e) in C:\Documents and Settings\uid\My Documents\Visual Studio
2005\WebSites\.......:line 350