Monday, August 13, 2007

Find arguments for a Procedure/Function within Package

//Find arguments to be Passed for a Procedure/Function within Package
// Package Name : INV_LOT_API_PUB
// Object Name (Method Name ): INSERTLOT
SELECT
*
FROM
user_arguments
WHERE
package_name LIKE 'INV_LOT_API_PUB'
AND
object_name LIKE 'INSERTLOT';

0 comments: