rowtype throws error when returning a value of a table

create a synonym for that table

executing a package method in TOAD

Declare

Variables in the package method

begin

assign the values to the IN PARAM

Call Package method by passing the paramaters

end;

example:

DECLAREi_account_update_reason_id ACCOUNT_UPDATE_REASON.account_update_reason_id%TYPE;o_account_update_reason_row ACCOUNT_UPDATE_REASON%ROWTYPE;BEGINi_account_update_reason_id:= 28;GUI_DATABASE_ACCESS. load_account_update_reason(i_account_update_reason_id,o_account_update_reason_row );END;

executing a package method in TOAD

Declare

Variables in the package method

begin

assign the values to the IN PARAM

Call Package method by passing the paramaters

end;