TOraclewwDataSet Ora-01031

[cosmini]

hi Marco,
we're having an issue w/ the TOraclewwDataSet in that we're getting an Ora 01031: insufficient prifilege. The insert works fine with the plain TOracleDataSet.

Here's the snipped of code:

the qCluster, a TOraclewwDataSet component's sql is defined as:

SELECT CL.ROWID, CL.*
FROM DCS.MYTable CL
WHERE CL.CLUSTER_PUB = :CID

I'm attempting to do something as simple as:
qCluster.InsertRecord([null, '070X06', Format('Auto Added %s',[DateTimeToStr(now)]), null];

when I get the error. Again, this works fine w/ a TOracleDataSet.

My TOraclewwData.pas is dated 3/15/99 however the DOA installation version is 3.4.6.4 I tried removing the component and reinstalling it but no luck.

thx much,
Cosmin

 

[Marco Kalter]

I can't imagine that the problem is specific to the TOraclewwDataSet. Perhaps you can use the Oracle Monitor to verify which SQL statement is being executed when this error occurs? This should provide a clue.

 

[cosmini]

thx much Marco for the tip.
I installed Ora Monitor 2.0 and surely enough I found the culprit in a sequence which had lost a grant....