I’ve been trying to display returned data in a grid from existing procedures in Toad for Oracle. I’m using the latest version of Toad 220.127.116.11
This is very simple in SQL Navigator. 1) You open a procedure 2) click a execute procedure button 3) enter the input parameter value’s 4) click Execute button one more time 5) click the cursor ellipsis button
This is something that I have to do on a regular basis.
Three procedures that run in SQL Navigator are not running in Toad. I 'm getting ORA-06550: line xx, column xx: PLS-00382: expression is of wrong type ORA-06550: line xx, column x: PL/SQL: Statement ignored.
Since I have potentially hundreds of procedures to work with, this could be a big deal.
Is there documentation I can reference that breaks down the process of simply returning data from procedure using Toad for Oracle?