Hi,
When I do :
OracleDSL.DBMS_AQ.ENQUEUE_OPTIONS_T options = new
OracleDSL.DBMS_AQ.ENQUEUE_OPTIONS_T();
OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T properties = new
OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T();
properties.attempts(2);
OracleDSL.DBMS_AQ.enqueue(context.configuration(), Queues.AQ$TASKS, new
Tp$queueTasksRecord(taskId, "ARES"), options, properties);
, I do get the following exception:
...
[main] DEBUG org.jooq.tools.LoggerListener - -> with bind values :
DECLARE
v_msgid RAW(16);
v_enqueue_options DBMS_AQ.enqueue_options_t;
v_message_properties DBMS_AQ.message_properties_t;
BEGIN
v_message_properties.attempts := 2
DBMS_AQ.ENQUEUE(
queue_name => 'AQ$TASKS',
enqueue_options => v_enqueue_options,
message_properties => v_message_properties,
payload => [UDT],
msgid => v_msgid
);
END;
[main] DEBUG org.jooq.tools.StopWatch - Exception : Total:
84.191ms
...
org.jooq.exception.DataAccessException: SQL [DECLARE
v_msgid RAW(16);
v_enqueue_options DBMS_AQ.enqueue_options_t;
v_message_properties DBMS_AQ.message_properties_t;
BEGIN
v_message_properties.attempts := ?
DBMS_AQ.ENQUEUE(
queue_name => ?,
enqueue_options => v_enqueue_options,
message_properties => v_message_properties,
payload => ?,
msgid => v_msgid
);
END;]; ORA-06550: line 7, column 3:
PLS-00103: Encountered the symbol "DBMS_AQ" when expecting one of the
following:
. ( * @ % & = - + ;
...
It seems to me there is a missing semicolon in the generated SQL statement.
Am I doing something wrong or is it a bug?
I' m using JOOQ Pro 3.5.3.
p.s:
Please take notice, I can run
OracleDSL.DBMS_AQ.enqueue(context.configuration(),
Queues.AQ$TASKS, new Tp$queueTasksRecord(taskId, "ARES"); without any
problem.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
