richards@uni2a.unige.ch (10/22/90)
I have recently started to use ORACLE and I have the following problem: I have written a SQLFORMS application on a VAX VMS machine running ORACLE V.5.1.22, SQLFORMS V.2.3.26 and I want to use the same application on a HP UNIX machine running ORACLE V.5.1.22.2 and SQLFORMS V.2.0.18. I have tried 2 things : 1) Using the command sqlforms user/pass@T:vaxname:sysid on the UNIX machine which gives me an ORA-3120 ttci2u integer overflow error. (The same command using sqlplus instead of sqlforms works fine and I can access the appropriate tables; sqlplus V.2.1.16 vax, V.2.1.11 HP) 2) I have transfered the application.inp file from the vax to the HP machine and I can load and run (unsuccessfully) the application but I am unable to save (ORA -0001 (!!) duplicate value in index). ( I do not have any indexes defined anywhere.) Please mail me directly with any help. Thanks.