Oracle problem in quering from remote database

2013-09-08  Source: Original Site  Category:Oracle  Views:0 


i have a table named "gatepass" in database A.
i created public synonym
(create public synonym gatepass for [email protected]) in database B for the table "gatepass" in database A.
when i query that table in db B through SQL prompt, it fetches data.
but when i query that table through form, form hangs(goes into working state) and ends.

where is the problem
plz help


Related articles
  • Oracle problem in quering from remote database 2013-09-08

    Hi i have a table named "gatepass" in database A. i created public synonym (create public synonym gatepass for [email protected]) in database B for the table "gatepass" in database A. when i query that table in db B through SQL prompt, it

  • Oracle Strange problem with data from remote database link 2015-01-28

    Hi I support a web based application that reads information from a remote database via a database link and synonyms on a local database on the web server. The local database is on Linux and the remote database is on Windows. All

  • Oracle Download/upload files from remote database 2012-09-01

    I am looking to upload/download files (word/pdf documents) from a remote database. What is the best way to do this? I have done this locally but with remote databases there are restrictions on lobs and we cannot use dbms_lob package on a remote datab

  • Oracle copying CLOB data from remote database to local database 2012-10-12

    How can i copy a CLOB data from a remote datbase table to a local database table ? i have a database link created from my local database to remote database, but looks like i cannot select a clob locator or clob data residing on a remote database thro

  • Oracle Getting LONG RAW from remote database 2013-01-05

    I have a table in my local database that has a LONG RAW column . I have another table of similar structure in a remote database (so it has LONG RAW as well). I would like to transfer data including LONG RAW data from the remote database into the loca

  • Oracle Select Lob data from remote database 2015-01-04

    How to access lob type data from a remote database using a database link? In this example clob_text is the clob data and mydblink is the database link: SQL> select clob_text from [email protected] where accnr=20030309; This give me an error: ORA-

  • Oracle Regarding Data copy from remote databases 2014-05-24

    We have two seperate databases (Oracle 9i). We want to transfer 10 million records of one table in database A to database B. The number of columns in the table are 35 most of which are defined as Number. Could anyone let me know the best and the fast

  • Oracle How to Execute Procdure from Remote Database ? 2013-01-21

    I have a procedure in my current database named GET_SP ( P_O OUT SYS_REFCURSOR) Which calls a procedure from remote database named GET_USER(P_OUT OUT SYS_REFCURSOR) using DATABASE LINK., /* Procedure in remote database */ create or replace procedure

  • Oracle How to access Clob data from remote database 2015-01-01

    I have a requirement to access real time data from remote database. Table contain the clob data. When I query remote database through db link it shows an error "You can’t select a CLOB over a database link". Then I searched on web and found solution:

  • Oracle How to use exp.exe export from remote database to local disk ? 2012-11-13

    How to use exp.exe export data from remote database to local disk ? Could you tell me? Thank you very much ! [email protected]

  • Oracle Copy data from remote database every 10 seconds 2014-08-27

    I have 9i locally and need to copy data from remote database that is 7.1.5. Since 7.1.5 doesn't support replication, I am using scheduled job(interval=10 seconds) to call following statement. insert into LOCALTABLE select * from [email protected] wh

  • Import from remote database 2014-04-12

    I am new on DB2 and even on MAB. I installed the DB2, SYnc server, MAB in my W2000 machine. I create on DB2 a database and a table and populate it. After that, I began to develop my application to Palm using MAB. I am having problems on import from a

  • Oracle Select LONG column from Remote table 2014-06-29

    I have the following problem: I can't select a LONG column from remote database, when there are Join operation in the query. Example: SELECT long_column FROM [email protected] -> that's OK, but: SELECT long_column FROM [email protected] INNER JOIN rem

  • Insert data from remote database 2012-03-21

    I am trying to insert data from a remote database to local database. I found some code on this site, but; I cannot get it to work. Code follows: Private Sub insertNewRec() ' This subroutine is used to insert accounting data ' into local database from

  • data send and recieve from remote database server via j2me program 2012-05-21

    hi, hello every 1...... plz help me to solve my question.... ~~ how to access data from remote database server from mobile through j2me program. ~~i wanna build a mobile application that can interact with the online database server like retreive cust

  • better way to get data from remote database 2013-06-25

    people i know maybe my question sounds stupid, but i want to get advice from you, from proffessionals. in my situation i talk about LAN client and server. Not about getting data trought internet. if i want to get data on the client side from remote d

  • upload all Public folder queries from production database to test database 2015-05-30

    How upload all Public folder queries from production database to test database. In my production database Public folder contains so many subfolder. Please guide me how do that.

  • Oracle copying table from remote database 2013-06-04

    i want to copy a table from a remote database. The problem is the remote database has the same name as my database name. how can i resolve this problem

  • Oracle How to send e-mail with an attachment from remote database server.??? 2014-12-31

    I have tried the simple mail sending and with the attachment using UTL_SMTP. But the problem is , it is sending the mail with attachment of the file name i give, it takes and creates that file and sends as attachment not from the actual file location

  • Oracle replicate some tables from local database server to Remote database sever 2015-02-01

    how can i replicate some tables from local database server(Oracle 8.1.7 on windows 2000 server) to a remote database server(Oracle 8.1.7 on Sun Solaris) whenever there is some insertion or updation on the table of base(main) database it should get up