|
|
| Re: Advanced Queueing in Forms [message #215444 is a reply to message #215425] |
Mon, 22 January 2007 05:42   |
orafan2003
Messages: 122
Registered: February 2006
|
Senior Member |
|
|
Hi,
I have two queues like this.
1) test_form_input_queue:
test_form_input_q_mt AS OBJECT(opportunity_id VARCHAR2(4000),customer_name VARCHAR2(4000),customer_address VARCHAR2(4000),customer_email VARCHAR2(4000),customer_phone VARCHAR2(4000), product_name VARCHAR2(4000), product_price VARCHAR2(4000));
2) test_form_output_queue:
test_form_output_q_mt AS OBJECT(opportunity_id VARCHAR2(4000),customer_name VARCHAR2(4000),customer_address VARCHAR2(4000),customer_email VARCHAR2(4000),customer_phone VARCHAR2(4000), product_name VARCHAR2(4000), product_price VARCHAR2(4000), proposer VARCHAR2(4000), expert VARCHAR2(4000) );
Now I have a form in which I want to dequeue the first queue and finally with all the details, I want to enqueue the second queue. How can I do this?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Advanced Queueing in Forms [message #215832 is a reply to message #215813] |
Wed, 24 January 2007 01:02 |
orafan2003
Messages: 122
Registered: February 2006
|
Senior Member |
|
|
Hi David,
This is the code that I am using to Dequeue in my forms application.
But when I compiled, I got the following errors.
DECLARE
dequeue_options DBMS_AQ.DEQUEUE_OPTIONS_T;
request_properties dbms_aq.message_properties_t;
request_msgid RAW(100);
my_msg test_form_input_q_mt;
BEGIN
DBMS_AQ.DEQUEUE ('test_form_input_queue',dequeue_options,request_properties,my_msg,request_msgid);
message ('Dequeued message id is ' || RAWTOHEX (request_msgid));
message ('Dequeued opp id is ' || my_msg.opportunity_id);
message ('Dequeued cust name is ' || my_msg.customer_name );
message ('Dequeued cust address is ' || my_msg.customer_address );
message ('Dequeued email is ' || my_msg.customer_email );
message ('Dequeued fone is ' || my_msg.customer_phone );
message('Dequeued prod name is ' || my_msg.product_name );
message ('Dequeued price is ' || my_msg.product_price );
END;
Error 512 at line 169,column 67
Implementation restriction:'REMOVE' Cannot directly access remote package variable or cursor
Error 0 at line 2,column 20
Item ignored
Error 512 at line 121,column 66
Implementation restriction:'NO_DELAY' Cannot directly access remote package variable or cursor
Error 0 at line 3,column 24
Item ignored
Error 320 at line 8,column 45
Declaration of the tyoe of this expression is incomplete or malformed
Error 0 at line 8,column 4
Statement ignored
This code works perfectly fine at the backend in SQL Plus (I replaced "message" with DBMS_OUTPUT.PUT_LINE to print the message) and dequeued.
What could be the problem in forms that I am getting the above mentioned errors. Please guide me.
Thanks.
|
|
|
|
| Re: Advanced Queueing in Forms [message #216078 is a reply to message #215832] |
Wed, 24 January 2007 23:14 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
All I can think of is that Forms does not like one of the data types. I suggest that you write your our database package/function/procedure, do the dequeue in that package and pass the information back to the Form via output parameters.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
