Skip to Main Content

SQL & PL/SQL

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!

How to initialize org in a view definition?

627118Jun 10 2010 — edited Jun 24 2010
Hi,
I am creating a custom view which uses Oracle standard function in the condition of the view definition. The function requires org intialization to provide the correct data. The view needs to be accessed in other DB instance via DB link.
So how should the org be initialized so that the view returns the correct data when accessed from the remote data base using the DB link?


Thanks!
Darshini
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2010
Added on Jun 10 2010
6 comments
2,589 views