Re: bug involving multiple IN/OUT parameters
"Amaury Forgeot d'Arc" <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAGmFidYFmBJaCMVBKYfabt=N5YiC_dTXP5wFfovv3qe9TKwwtg@mail.gmail.com> |
2013/8/28 Michael Bayer <[email protected]> > # z=IN, x=OUT, y=OUT, breaks every time in this case: > # ORA-24369 required callbacks > # not registered for one or more bind handles > # different combinations work/fail somewhat randomly, though > deterministically > # for a given combination. > cursor.execute( > "INSERT INTO t1 (y, z) VALUES (1, :z) RETURNING t1.x, t1.y INTO > :x, :y", > {"z": 1, "x": x, "y": y}) > According to documentation, it's even surprising that it works sometimes: http://docs.oracle.com/cd/B10501_01/appdev.920/a96584/oci05bnd.htm#420693 """ Even if the application can be sure that it will only get a single value back in the RETURNING clause, it must still bind in OCI_DATA_AT_EXEC mode and use callbacks """ cx_Oracle has no support at all for this OCI_DATA_AT_EXEC. -- Amaury Forgeot d'Arc ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users