Editing attached libraries [message #90347] |
Thu, 03 February 2005 09:21 |
Sion
Messages: 2 Registered: February 2005
|
Junior Member |
|
|
Hi,
probably a very simple question but I'm stumped.
In Oracle Reports is it possible to edit PL/SQL libraries stored in the database (not as .pll file on the filesystem)?
The 'Building a Report with Ref Cursor Queries' tutorial from Oracle explains how to store PL/SQL code as libraries in the database. At the end of the tutorial (6.8) it suggests you delete the PL/SQL on the client which leaves just the saved libraries in the database. It doesn't explain how you can edit them again!
Thanks for any advice,
Sion
|
|
|
Re: Editing attached libraries [message #90351 is a reply to message #90347] |
Fri, 04 February 2005 01:56 |
Sion
Messages: 2 Registered: February 2005
|
Junior Member |
|
|
To answer my own question:
To open a PL/SQL Library stored on the database:
1. Tools -> Preferences
2. Access -> Database (or File/Database)
By default this is set as File.
Regards,
Sion
|
|
|