Skip to Main Content

Oracle Database Discussions

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!

Can I Call FND_FILE.PUT_LINE from another schema

580861Mar 28 2008 — edited Apr 3 2008
I have a package on XYZ schema. It runs through Oracle App's concurrent program. I want to write logs to the concurrent program's log file. It said we can use FND_FILE.PUT_LINE to do so. So I did following:

GRANT execute ON APPS.FND_FILE TO XYZ;

And call FND_FILE.PUT_LINE in my package.
fnd_file.put_line(fnd_file.log, 'Queue is ' || x);

When I compile, it says

Compilation errors for PACKAGE ....

Error: PLS-00201: identifier 'FND_FILE.LOG' must be declared
Line: 111

What do I miss?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2008
Added on Mar 28 2008
2 comments
5,076 views