[cx-oracle-users] Callproc and Oracle.NUMBER problem.

[Brown, S. <Ste...@wo...>]

Hi,

I use Python 2.6.6 with cx_Oracle 5.1.2 and Oracle DB Client 11.2..0.2.0. I cannot upgrade to Python 2.7.

I have the following stored procedure signature:

CREATE OR REPLACE PROCEDURE insert_task_execution(
    vId OUT task_execution.Id%TYPE,
    vJob_id IN task_execution.job_id%TYPE,
    vInitiated_by IN task_execution.initiated_by%TYPE,
.
.
.

The table definition is:

CREATE TABLE task_execution
(
   id                INTEGER                NOT NULL,
   task_summary_id   INTEGER                NOT NULL,
   job_id            INTEGER                NOT NULL,
   initiated_by      VARCHAR2(16 CHAR)      NOT NULL,
.
.
.
   CONSTRAINT        pk_task_exe            PRIMARY KEY (id),
   CONSTRAINT        fk_task_exe_summary    FOREIGN KEY (task_summary_id) REFERENCES task_summary(id)
);

I call cursor.callproc like this:

connection = cx_Oracle.connect(connectionString)
cursor = connection.cursor()
newRecordId = cursor.var(cx_Oracle.NUMBER)
parameters = [newRecordId, 123, initiatedBy, ... ]
cursor.callproc('insert_task_execution', parameters)

I get this exception before any database access.:


cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data type cx_Oracle.NUMBER


Can someone tell me what I'm doing wrong, and how to fix it?

Many thanks,
Steve
This e-mail and any attachments are confidential, intended only for the addressee and may be privileged. If you have received this e-mail in error, please notify the sender immediately and delete it. Any content that does not relate to the business of Worldpay is personal to the sender and not authorised or endorsed by Worldpay. Worldpay does not accept responsibility for viruses or any loss or damage arising from transmission or access.

Worldpay (UK) Limited (Company No: 07316500/ Financial Conduct Authority No: 530923), Worldpay Limited (Company No:03424752 / Financial Conduct Authority No: 504504), Worldpay AP Limited (Company No: 05593466 / Financial Conduct Authority No: 502597). Registered Office: The Walbrook Building, 25 Walbrook, London EC4N 8AF and authorised by the Financial Conduct Authority under the Payment Service Regulations 2009 for the provision of payment services. Worldpay (UK) Limited is authorised and regulated by the Financial Conduct Authority for consumer credit activities. Worldpay B.V. (WPBV) has its registered office in Amsterdam, the Netherlands (Handelsregister KvK no. 60494344). WPBV holds a licence from and is included in the register kept by De Nederlandsche Bank, which registration can be consulted through www.dnb.nl. Worldpay, the logo and any associated brand names are trade marks of the Worldpay group.