Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

Accessing from form6i to Table data throw a database link

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
jesules
Asked:
jesules
  • 2
  • 2
1 Solution
 
jpkempCommented:
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
 
jesulesAuthor Commented:
The message is ORA-03120 in both.
0
 
jesulesAuthor Commented:
The message is ORA-03120 in both.
0
 
jpkempCommented:
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now