I've created a project simular to the TimeTracker application. I have a class WDACarpool which inherits from the WDABase class.
It has a method getUsersBySchedule which returns a dataset from a pl/sql procedure. The pl/sql procedure works when testing it in SQLPlus. Yet in VB
.NET, I can't get it to work.
Two of the IN parameters in this procedure are of type 'DATE'. How are these supposed to be added to the command? I can't use either myBase.AddParameter() method since Date doesn't have a size and since it's an input parameter.
Now, i've changed the parametertype's in both pl/sql procedure and vb
method to VARCHAR2/String. I convert them to DATE within the pl/sql procedure, but it still doesn't give me any records, while it should give me one record.
The pl/sql procedure still works under SQLPlus.
Where should I begin to solve this problem?