Re: [cx-oracle-users] How to pass record data type to oracle procedure.

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

Hi,

>From what I understand, RECORD cannot be passed via OCI. It is a
PL/SQL only construct like booleans. So this cannot be done directly.
You will need to do something like this instead:

sql = """
declare
    t_Options dbms_aq.options_t;
begin
    t_Options.relative_msgid := :msgId;
    dbms_aq.enqueue(:queueName, t_Options....);
end;"""

cursor.execute(sql, msgId = '??', queueName = '??')

Expand as needed for the other items.

Hope that helps.

Anthony

On Sun, Oct 16, 2011 at 9:30 PM, yi huang <yi....@gm...> wrote:
> I want to call this procedure 'DBMS_AQ.ENQUEUE', but it requires a parameter
> with type `DBMS_AQ.DEQUEUE_OPTIONS_T', how can i construct this data in
> python?
> Best regards.
>
> --
> http://www.yi-programmer.com/blog/
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>