ORA-06550: Line 1, Column 7: PLS-00306 Fustration
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 ...