Re: cannot find source of error compiling procedure.

On 28 Feb 2002 11:49:26 -0800, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>In article <3c7e4ac0.154818006_at_ausnews.austin.ibm.com>,
>Ed_Stevens_at_nospam.noway.nohow says...
>>
>>Platform: Oracle 8.0.5 SE on NT 4, sp6
>>
>>I'm building a test version of one of our production db's. I did a "schema
>>extraction" to get all of the tables, indexes, procedures, etc. from a
>>particular schema. When I executed this DDL on the test database, everything
>>went will except for compiling a few of the procedures. On the procedures, I
>>got the error "ORA-04054: database link LN_NMMPDB.WORLD does not exist"
>>
>>OK, that refers to a link to a production database, so I'll just change to
>>reference to point to the proper link in the test environment. BUT . . . I
>>can't find any occurance of the string "LN_NMMPDB" anywhere in the DDL!
>>
>>So if the DDL has no mention of LN_NMMPDB, why would the compile fail because
>>LN_NMMPDB does not exist?
>>
>>Sitting on a park bench, feeding the birds and drooling on myself is looking
>>better all the time . . .
>>
>>
>>--
>>Ed Stevens
>>(Opinions expressed do not necessarily represent those of my employer.)
>
>
>perhaps a synonym used in the code hides the existence of the dblink.
>

<snip>

DOH! Of course that was it . . . Now, where did I put that AARP card? . . . .

Thanks. Sometimes it takes another set of eyes to see the obvious.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)