calling a package function from another schema
kcjimAug 22 2007 — edited Aug 22 2007I've created a pl/sql package containing a procedure in the sys schema. What do i need to do to be able to call that procedure from within another schema, one called kcapps? Currently, from sql plus, i'm trying something like this:
execute row_level_security_pkg.set_app_operdefn('steve');
i've even tried to reference the schema name before the package, like this:
execute sys.row_level_security_pkg.set_app_operdefn('steve');
what do i need to do to be able to call this procedure which belongs to a package that lives in another schema? Thanks.