IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New I think it has something to do with the @ symbol
@ is the remote location indicator. This is from the PL/SQL reference -

Doing Remote Operations
As the following example shows, PL/SQL subprograms can execute dynamic SQL
statements that refer to objects on a remote database:
\nPROCEDURE delete_dept (db_link VARCHAR2, dept_id INTEGER) IS\nBEGIN\nEXECUTE IMMEDIATE \ufffdDELETE FROM dept@\ufffd || db_link ||\n\ufffd WHERE deptno = :num\ufffd USING dept_id;\nEND;

Also, the targets of remote procedure calls (RPCs) can contain dynamic SQL
statements. For example, suppose the following standalone function, which returns
the number of rows in a table, resides on the Chicago database:
\nCREATE FUNCTION row_count (tab_name VARCHAR2) RETURN INTEGER AS\nrows INTEGER;\nBEGIN\nEXECUTE IMMEDIATE \ufffdSELECT COUNT(*) FROM \ufffd || tab_name INTO rows;\nRETURN rows;\nEND;

From an anonymous block, you might call the function remotely, as follows:
\nDECLARE\nemp_count INTEGER;\nBEGIN\nemp_count := row_count@chicago(\ufffdemp\ufffd);
New Another reference
Says it can be done, but you can not access package constants, exceptions, or cursors. Doesn't actually say how you do it though.
New That second bit is what I was looking for.
One of the other developers here came to ask me how to do this; she was already referencing remote tables but didn't know if she could call remote packages.

I'll pass it on, thanks.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Calling remote Oracle PL/SQL packages from PL/SQL - (admin) - (3)
         I think it has something to do with the @ symbol - (ChrisR) - (2)
             Another reference - (ChrisR)
             That second bit is what I was looking for. - (admin)

And if I'm just going for effect, I might as well wear a tie. And pants.
65 ms