Re: Stored Procedure and Table

Not trying to be a twit, but prefixing your tables with 't_' and your procedures with 'pr_' and your packages with 'pkb_' for package body and 'pks_' for package specs as development standards kind of takes care of this problem.

"Mabel" <mabelle_at_bluewin.ch> wrote:

>It os because the object name is unique for each object of the owner. You
>have to rename your procedure or your table.\
>Mabel,
>
>Goofyrich <goofyrich_at_aol.com> wrote in article
><19980109051500.AAA13843_at_ladder02.news.aol.com>...
>> I was trying to create a stored procedure with a name that was used by a
 table.
>> Oracle 7.3 somehow confused and gave me an error saying the object is
 already
>> existed. When I rename that table, the stored procedure worked!
>>
>> Has anyone encounter this problem?? Any suggestions as how to get around
 this
>> problem? Thanks in advance
>>
>> -daisy
>>
Received on Sat Jan 10 1998 - 00:00:00 CET