Toad World® Forums

Running a Procedure with an imbedded table gets error on execution.


#1

TYPE t1_msg is TABLE of VARCHAR2(200)

INDEX BY BINARY_INTEGER;

PROCEDURE move_rma_to_loc_sp

(

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

);

IN_WH_ID VARCHAR2(10);

IN_RMA_NUMBER VARCHAR2(30);

IN_LOCATION_ID VARCHAR2(50);

OUT_MSG PL/SQL TABLE;

IN_WH_ID VARCHAR2(32767);

IN_ITEM_NUMBER VARCHAR2(32767);

IN_ITEM_UOM VARCHAR2(32767);

OUT_MSG DBO.XXWIR_NOTIFICATIONS_PKG.T1_MSG;

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:
DECLARE
It should resolve the table like it does for another procedure I copied like:
DECLARE
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.

RM