Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cx_Oracle, version 5.1.2, Oracle DB 11.2.0.2.0, and Python 2.6.6 - NUMBER variables and callproc

srbrown1Feb 12 2015

Hi,

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:

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

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

Many thanks.

Comments

Christian Pitet

What means BIP ?

User_TYVZT

Hi Christian Pitet

Oracle Business Intelligence Publisher (BI Publisher) (BIP)

Christian Pitet

I guess you are using an Interactive report. Do you have a Submit page process on that page ?

InoL

While generating report in BIP, that data is saved as sample data.
What do you mean by that? Generating a report via BI Publisher and saving sample data? I don't see the connection.
How are you using BIP? As the print server for Intercative Reports? Or a custom report template?

User_TYVZT

Hi InoL
So for creating report, I have xdm(data model) and xdo. In xdm, after providing the sql query, I can see the data when I click view data. There I can do "save as sample data". Then after link my data model with xdo which has template in it, I can view my report in various formats. There even though there is data I'm not able to see the data in xls and pdf format. Only CSV format report shows data.

InoL

I have xdm(data model) and xdo
I have no idea what that is, not APEX anyway. Is this something from BI Publisher? Maybe you can ask this in that forum then.

User_TYVZT

Hi InoL
Yes it is from BI Publisher(BIP). Could you share forum link?

Christian Pitet

Here is a forum link :
bi publisher (0 Bytes)Regards.

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 12 2015
Added on Feb 12 2015
0 comments
1,436 views