Doh, I replied to Jared only. Here it is:
-----Original Message-----
I knew that was coming. :) Should of explained in the last e-mail.
Sorry, was busy with many things.
The error ora 1017 says "logon denied". That got me chasing all
the connection stuff. Turns out the package uses a remote sequence
that I forgot to create a synonym for. If the PL/SQL stack trace
didn't bomb with ora-600 [17090], I would probably found it sooner.
Richard Ji
-----Original Message-----
Sent: Thursday, June 05, 2003 5:26 PM
To: [EMAIL PROTECTED]
Cc: Richard Ji
Importance: High
and what did you do to solve it?
"Richard Ji" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/05/2003 03:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: FW: ora 1017 -solved
Never mind, I solved. Man, that error message is misleading. :)
> -----Original Message-----
> From: Richard Ji
> Sent: Thursday, June 05, 2003 4:46 PM
> To: Multiple recipients of list ORACLE-L (E-mail)
> Subject: ora 1017
>
> Hi,
>
> I am accessing a table over database link, which I am able
> to select, insert, delete from etc.
>
> Now I have a package locally that does insert, delete on that
> remote table but when I run the package, I get ora 1017. But
> from SQL*Plus I can do my select, insert, delete just fine.
>
> If I drop the synonym and create a real table locally, everything
> works.
>
> I also tried to do a PL/SQL stack trace and got an ora-600.
>
> Any ideas?
>
> Thanks
>
> Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
