[Qgis-user] Can't access Oracle sequences

[Jürgen E. Fischer]

Hi Sylvain,

On Mon, 16. Mar 2015 at 18:01:35 +0100, PIERRE Sylvain wrote:
> With Postgis/QGIS configuration I can manage sequences on primary key when
> editing  new object (editing forms show a nextval(‘xxxxxxxxxx’::regclass)
> formula in pk field)
> With my Oracle/QGIS conf I can’t manage sequences, and editing failed when I want to save.
> Where is the problem?
> Is it an Oracle provider issue ?

Not really.

In PostgreSQL the sequence value is retrieved by a default expression.  In
Oracle sequences used to be retrieved and assigned to the new record using a
before insert trigger.  But in Oracle 12c you can also use default values to
retrieve and assign the next sequence value.  I suppose that works in QGIS too,
but I don't currently have setup a 12c to verify.

So unless you have 12c with a default value, you have to have a trigger to deal
with assigning the key value.



Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150316/878b56dc/attachment.sig>