Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: WebDB - Can I repopulate tables?
On 09 Sep 1999 15:45:53 GMT, timkarnold_at_aol.com (TimKArnold) wrote:
>Hi,
>
>Is is possible to populate WebDB tables with a SP that
>already exists? My problem is that I installed v2.1 without
>exporting the existing tables. Now I have valid stored procedures
>but WebDB no longer 'sees' them.
Tim,
Without the repository, WebDB is unable to manage the stored procedures, even if it originally generated it. There is no way for it to decompose an existing stored procedure back into its repository. So, unless you have the original repository tables, I'm afraid that your only choice is to recreate them in the new version of WebDB or never use WebDB to modify the existing stored procedures. Sorry :-(
chris.
>
>TIA,
>Tim
--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.