🚀 go-pugleaf

It seems that Oracle 7.3.2 SERVER (Rdbms) have a problem affecting
LONG columns. When inserting a new row into ( or updating an existing
row in ) a table containning a LONG column you get an error.

My Chief said to me to install an Oracle 7.3.2 in a new machine (
HP-9000(?) HP-UX 10.1? ). I did it, but because it didn't came with
FORMS30, MENU50 an REPORTS1.1.10.x/1.1.14.x, I got(install) it from an
7.2.2)

I had severel problems to solve: Portuguese charset, get applications
from the old machine, etc and at the end all seemed ok ( all things
make me believe tha they are solved ).

Next day I recieved an call!. They couldn't update the queries in
SQL*REPORT 1.x. The error was: ORA-02014: cannot select FOR UPDATE
from a view with DISTINCT, GROUP BY, etc.
This happen all times evem if you only have "select * from test_table"

So, I had tried to relink executables, drop srw tables, rebuild srw
tables, etc. Then I had remember to create a form for this table:
	create table test_1(a number, b long);

I had done it because the query is stored in SRW_QUERY ( SRW__QUERY,
depend how you install srw tables and users ) in a LONG column. 

After generate and execute the form I find that we can insert an
select from test_1 table but if we tried an update we receive a
"ORA-40501 error: unable to reserve record for update or delete",
in any situation.

Then I tried insert/update with (Developer) SQLPLUS and it worked.
Next was FORSM4.5 and I got error only if I tried to update a newly
inserted record.

If REPORTS 1.x tries to lock the record by using SELECT ... FOR
UPDATE, them it might be possible that is because this "ORACLE known
problem" that reports isn't working. Well "some" people had said to
"ask your boss who told him to install REPORTS 1.x in a 7.3.2" or to
wait for an version of Oracle7 higher than 7.3.2 or for a patch for
bug# 348967.

I would like to know if someone else have extra information/solutions
or managed to install REPORTS 1.x in a 7.3.2 Oracle base.

							Thanks in advance

							FERNANDO DINIZ