Home » Developer & Programmer » Forms » Advanced Queueing in Forms
Advanced Queueing in Forms [message #215425] Mon, 22 January 2007 04:22 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
How can we use Advanced queing in Forms 10g R2 ? Are there any examples? Please provide me pointers.

Re: Advanced Queueing in Forms [message #215444 is a reply to message #215425] Mon, 22 January 2007 05:42 Go to previous messageGo to next message
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 #215551 is a reply to message #215444] Mon, 22 January 2007 18:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Just write it in PL/SQL package in the database and call it.

David
Re: Advanced Queueing in Forms [message #215581 is a reply to message #215551] Tue, 23 January 2007 00:08 Go to previous messageGo to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
David,
Can you please give me an example? I am not clear.
Thank you.
Re: Advanced Queueing in Forms [message #215757 is a reply to message #215581] Tue, 23 January 2007 15:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The only example I could give would be out of the Advancing Queuing Reference Manual and you can do that as easily as me.

David
Re: Advanced Queueing in Forms [message #215813 is a reply to message #215757] Wed, 24 January 2007 00:12 Go to previous messageGo to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Thanks David...It helped!
People looking for AQ can refer to http://www.unix.org.ua/orelly/oracle/bipack/ch05_04.htm

[Updated on: Wed, 24 January 2007 00:13]

Report message to a moderator

Re: Advanced Queueing in Forms [message #215832 is a reply to message #215813] Wed, 24 January 2007 01:02 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: open pdf files using forms 10g
Next Topic: Need Help Regarding Migration To Forms10g
Goto Forum:
  


Current Time: Tue Dec 06 06:18:00 CST 2016

Total time taken to generate the page: 0.07552 seconds