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

[Anthony T. <ant...@gm...>]

Hi,

I have no idea what the problem is with your situation, unfortunately! Even
if you can't upgrade to Python 2.7 for your project, though, you can at
least install Python 2.7 and cx_Oracle 5.1.3 to determine if it is a
problem with your older environment. It would also help to know the exact
line at which it fails.

Anthony

On Fri, Feb 13, 2015 at 1:50 AM, Brown, Steve <Ste...@wo...>
wrote:

>  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.
>
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>