Thursday, December 3, 2009

Unable to View Procedure Source in TOAD - 'IN' is not a valid integer value

Description:
I unable to procedure source from Toad Schema browser. Below error message I got,
'IN' is not a valid integer value

Solution Tried:
Step 1: I logged in as Schema Owner
Step 2: Created the below view.
CREATE OR REPLACE FORCE VIEW schema_owner.all_arguments
AS
SELECT owner, object_name, package_name, object_id, overload,
argument_name, POSITION, SEQUENCE, data_level, data_type,
DEFAULT_VALUE, default_length, in_out, data_length, data_precision,
data_scale, radix, character_set_name, type_owner, type_name,
type_subname, type_link, pls_type, char_length, char_used,
subprogram_id
FROM SYS.all_arguments;
Step 3: Refresh schema browser.
Finally, I was able to view the procedure source

No comments: