w*m
发帖数: 1806 | 1 Hi all,
I created an package aa in shema a. inside this package, I have a
function aaa, now I want to use a.aa.aaa(xxxx) in schema b.
how can I make it works in schema b?
in schema b, I launch this function like this: aa.aaa(xxx);
thanks | v*****r
发帖数: 1119 | 2 1. Grant execute privilege on package aa to schema b
2. Create public synonym for package aa; or create private synonym for
package aa inside schema b.
also function aaa needs to be exposed in package aa specification.
【在 w*m 的大作中提到】
: Hi all,
: I created an package aa in shema a. inside this package, I have a
: function aaa, now I want to use a.aa.aaa(xxxx) in schema b.
: how can I make it works in schema b?
: in schema b, I launch this function like this: aa.aaa(xxx);
: thanks
| w*m
发帖数: 1806 | 3 thanks. problem resolved.
【在 v*****r 的大作中提到】
: 1. Grant execute privilege on package aa to schema b
: 2. Create public synonym for package aa; or create private synonym for
: package aa inside schema b.
: also function aaa needs to be exposed in package aa specification.
|
|
