Testing a procedure

[misuk11]

I have a procedure within a package that takes several input paramaters and returns a recordset. If I activate the TOraclewwQuery component from Delphi I get an error 'Invalid SQL statement'

Its quite a complicated procedure, Ive tested the individual bits of SQL within it and they work OK, but I have used several cursors. Can anyone show me how I could test this procedure from within PL/SQL developer ?

 

[Marco Kalter]

Just right-click on it and select "Test" from the popup menu. After execution you can view the cursor result set by clicking on the value cell button (...) of the cursor variable.