Search results for query: *

What you need to do is create the function/stored procedure in the remote database, create a link between the two, and use EXECUTE IMMEDIATE to call the function. Here's an example of a SELECT: EXECUTE IMMEDIATE 'SELECT CRDPTR_LOGLOC_ID FROM GW_CRDPTR_LOGLOC@' || wk_card_location || ' WHERE...

Check documentation on the DBMS_JOB package. This will run a stored procedure at a specified interval or time.

Here's something from Oracles documentation: Distributed LOBs are not supported. Specifically, this means that the user cannot use a remote locator in the SELECT and WHERE clauses. This includes using DBMS_LOB package functions. In addition, references to objects in remote tables with or...

Duh! A simple "INSERT INTO ... SELECT * FROM BLOB_TABLE WHERE ..." worked just fine! It's often the simple things that are the hardest to see. Thanks for the reply.

Help!! I'm attempting to copy a BLOB from one database to another located on a seperate machine. I can insert an empty_blob() into the remote database but can not find any method of getting the actual BLOB there. If I attempt to DBMS_LOB.WRITE the record inserted with the empty_blob(), I...

Have you tried a TNSPING to see if you can ping the database, not just the machine? Something that's happened to me, too often, is I have two Oracle client directories on my machine, Network and Net80. I have to be sure to update the TNSNAMES.ORA files in both. Do a search on your client PC...

I disagree about the dynamic SQL comment. I'm using dynamic SQL in 8.0.x and 8.1.x and find it quite effective. I'm doing the same thing as you, calling the same stored procedure in a number of distributed databases. In Oracle 8.1.6 it looks like this: wk_sql_stmt := 'BEGIN :1 :=...

Since you didn't specify the language your front-end is written in it's a little difficult to give an exact answer. I write in VB and to do this with ADO as the middleware declare a variable as a ADO Recordset and then use an ADO Command object to send the SQL to Oracle and return an ADO...

Try this link: http://support.microsoft.com/support/kb/articles/q176/0/86.asp?LN=EN-US&SD=gn&FR=0