TYPE t1_msg is TABLE of VARCHAR2(200)
INDEX BY BINARY_INTEGER;
in_wh_id IN t_item_master.wh_id%TYPE
,in_rma_number IN t_item_master.item_number%TYPE
,in_location_id IN t_stored_item.location_id%TYPE
,out_msg OUT t1_msg
OUT_MSG PL/SQL TABLE;
I’ve got a issue with a new package containing a procedure I’m trying to execute and test thru Toad.
In the package spec, I’ve defined a msg table as such:
and the procedure as
When I execute the proc, it cannot find the t1_msg table and so it won’t resolve correctly. It generates a declare that looks like:
It should resolve the table like it does for another procedure I copied like:
I had two other guys try it and it resolves fine for them. So what option needs to be set in my Toad configuration to resolve this?
This has been quite annoying and none of us know how my profile is different than theres. And we all log onto Toad with the same userid to work on these packages, so the error is not there.
Any help would be appreciated.