Both types of procedures are represented as rows in the SYSTEM.TABLE catalog table. The default SYSCA.ACCESSIBLE_PROCS view returns only procedures defined with the CREATE PROCEDURE syntax (table type = 'R'). You can customize the view to return table procedures by modifying the filter clause to include type 'P' as well as type 'R'.
|
Copyright © 2009 CA.
All rights reserved.
|
|