StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7874858
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-10-24T11:23:05.613
FavoriteCount
0
LastActivityDate
2011-10-24T11:23:05.613
LastEditDate
LastEditorUserId
0
OwnerUserId
62881
ParentId
7839530
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
OK so I was able to get this working, of sorts. It turns out that when creating the database link, the double quotes around the username and password fields were causing the issue. To summarise: If they were present, and the link created as so: <pre><code>create database link remote_link connect to "remote_user" identified by "remote_pass" using 'REMOTE_DB'; </code></pre> <ol> <li>The remote database could be queried via sql</li> <li>The stored procedure could not be compiled, recieving the ORA-942 error</li> <li>As the procedure could not be compiled, it could not be executed</li> </ol> When the double quotes are not present: <pre><code>create database link remote_link connect to remote_user identified by remote_pass using 'REMOTE_DB'; </code></pre> <ol> <li>The remote database could not be queried via sql, recieving an invalid password error (detailed in the question)</li> <li>The stored procedure could be compiled with no errors.</li> <li>The stored procedure executes as expected, retrieving data from across the database link, and displaying it.</li> </ol> So, even though the remote database cannot be querued via sql, recieving an invalid password error, the procedure that uses this same connection information compiles and executes normally. I'm sure you'll agree, this is a curious state of events, and I genuinely stumbled across making it work in my scenario. I'm not quite sure I would call it a solution, as there are plenty of unanswered questions. Hopefully if someone comes here via google, they'll find this answer useful, and at least get their code running. GC.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POOracle: Using a database link in a stored procedure : table or view does not exist
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USClarkey
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POOracle: Using a database link in a stored procedure : table or view does not exist
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COStill can't let this one go... Looks like the password on 11g is case sensitive and benefits from being put in quotes. Found from this blog entry: http://pbarut.blogspot.com/2008/08/db-link-to-oracle-11g.html
 singulars
 PostPostId
 PO
 UserUserId
 USClarkey

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.