Taliskers Life and Doings

Here the other day I was creating a procedure in Oracle, which in return I was to execute from my VB.NET code. I got the procedure working from TOAD and I was to implement the solution into my VB.NET code. When I did so, I got error message ORA-06550: Line 1, Column 7: PLS-00306 error when calling the code. After searching the net for solution (which was hard to find in the first page of google's search as many had the problem but no exact answer was given). This problem is related to calling a stored procedure with an out parameter, and to solve this issue it is important that you call the parameter name in your VB.NET code the same as the name used in the CREATE or REPLACE PROCEDURE statement. To give you an example; Oracle Procedure: CREATE OR REPLACE PROCEDURE test_proc (     random_number OUT NUMBER ) IS BEGIN     random_number := 100 ; END ; VB.NET Code:   Using oraCon As OracleConnection = OCSBase. MSDataAccess . GetDbConnection   ...

When using asp:UpdatePanel and jQuery datePicker function in the ui library, there is a need to register an event handler on the textbox/input field used to bind the datepicker in order to initialize the datepicker again. If you are using a Custom User Control where you do not know if you have a page with update panel you can use the following method to look in the page for the update panel VB.NET   Public Shared Function FindCondtrolOfType ( ByVal controls As List ( Of Control ) , ByVal t As Type, ByVal parentControl As Control ) As List ( Of Control )    For Each c As Control In parentControl. Controls     If c. GetType ( ) . Equals ( t ) Then     controls. Add ( c )     End If     If c. HasControls Then     controls = FindCondtrolOfType ( controls, t, c )     End If    Next  ...

When updating your custom control in your bin folder to a newer version, I got an error that Type is not defined. Solution: Edit your project file (in notepad++ or similar) and update your version number to the one corresponding to your latest version. <Reference Include="assembly.name, Version=1.1.0.0, Culture=neutral, processorArchitecture=MSIL"> This will allow the project to compile again. Hope this is of any help.