?
Solved

Accessing from form6i to  Table data throw a database link

Posted on 2003-03-27
6
Medium Priority
?
461 Views
Last Modified: 2012-06-21
I have two Oracle 9i Databases (A,B). There is a DAtabase Link from A to B. When a client using Form6i, connected to A, attemp to access B table with a Database link, get the message FRM-40507. This problem didn't exist when A database was 8i. When I use a 9i client, I have no problem.

Can anybody help me?
0
Comment
Question by:jesules
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 5

Expert Comment

by:jpkemp
ID: 8222420
Please try the following:

1. Connect using SQL*Plus to A and try to access the table in B (e.g. do a SELECT * FROM mytable@B_LINK).

2. In Forms, when FRM-40507 appears, invoke Help menu->"Display Error" and report any messages it shows.

Let us know what happens.

Jeff
0
 

Author Comment

by:jesules
ID: 8223631
The message is ORA-03120 in both.
0
 

Author Comment

by:jesules
ID: 8223674
The message is ORA-03120 in both.
0
 
LVL 5

Accepted Solution

by:
jpkemp earned 300 total points
ID: 8235738
Thanks jesules

"ORA-03120 two-task conversion routine: integer overflow
Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.
Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767."

I haven't come across this before. You could try the suggestions above if you haven't already, otherwise it may be a bug in 9i - I suggest that you post this on Metalink (http://www.oracle.com/support/metalink/).

Sorry I couldn't help.

Jeff
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question