Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Network constraint: getting to work

525407Nov 19 2007 — edited Nov 19 2007
Hello all,
I've set up a network with own data on which I can calculate basic routes. This data mixes walk links (un directed) with bus links (directed).
I choosed to set up only a network defined undirected.

The intention is to set up a constraint that filters links as needed.

The basic constraint I am trying to get to work simply constructs the "isSatisfied" function returning true.
I compiled and registered it with no errors.

The problem is when using it, I get error:
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "MDSYS.SDO_NETWORK_MANAGER_I", line 295
ORA-06512: at "MDSYS.SDO_NETWORK_MANAGER_I", line 128
ORA-06512: at my proc line where I do:
path_id := sdo_net_mem.network_manager.shortest_path('PMRS_NETWORK', fromNode, toNode, 'AmbConstraint');

I'm working with a user with connect and resource roles on Oracle 10gR2.

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2007
Added on Nov 19 2007
2 comments
844 views