 How AQ is related to dbms_job [message #126479] |
Tue, 05 July 2005 03:33  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
hi gurus,
I am new to Advance Queuing(AQ) .How dbms_job is related with AQ.Is AQ is for messaging purpose only.or it will behave same as dbms_job.If what is the difference.
Please reply,,
Thanks
Dinesh
|
|
|
|
| Re: How AQ is related to dbms_job [message #126501 is a reply to message #126479] |
Tue, 05 July 2005 04:44  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
DBMS_JOB is a job scheduler only. It may or may not kickoff jobs that use AQ technology. In Oracle 10g, there is a better scheduler called DBMS_SCHEDULER.
AQ is a queuing technology that is used to asynchronous enque, deque, and propagate messages (the payload).
The “PL/SQL Packages and Types Reference” Manual contains more complete descriptions of both.
Best regards.
Frank
|
|
|
|
| Re: How AQ is related to dbms_job [message #126504 is a reply to message #126501] |
Tue, 05 July 2005 05:20 |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
hi,
Frank thanks for your reply.Actually one of my procedure is running currently through the dbms_job.But i have been told that the procedure should go with AQ.
So can you please explain,how i will put this oracle stored procedure in a AQ,and how it will behave.
Thanks
With regards
Dinesh
|
|
|
|
| Re: How AQ is related to dbms_job [message #126509 is a reply to message #126504] |
Tue, 05 July 2005 05:36 |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
Hi frank,
I got a link in asktom,but unable to understand it,can u pls explain it(don't mind).
---Message Strat Here-------------
Tom,
My question is related with the original question. I made a copy of your
"notifyCB" procedure in my 8.17 environment but when I compiled the procedure ,
it gave me "PLS-00201: identifier 'SYS.AQ$_REG_INFO' must be declared" error.
When I asked my DBA to look into, he replied me back that this object does not
exist in 8i but it exist in 10G.
I neeed to call a pl/sql procedure after a message is enqueued in a queue, how
would I do it in 8.1.7 environment?
Thanks for your help.
Suhail
Followup:
this was a new feature in 9i -- plsql based callbacks.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96587/qwnew.htm#969817
---------Message End Here------------
My environment is 9i,then how can i substitute my dbms_job for submitting the procedure with AQ for submitting the same procedure.
Thanks
Dinesh
|
|
|
|
| Re: How AQ is related to dbms_job [message #127029 is a reply to message #126509] |
Fri, 08 July 2005 00:46 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Chapter 2 of the same manual explains the callback mechanism:
"CALLBACK - Specifies the action to be performed on message notification.
For e-mail notifications, the form is mailto://xyz@company.com
For AQ PL/SQL Callback, use plsql://<schema>.<procedure>?PR=0 for raw message payload or plsql://<schema>.<procedure>?PR=1 for ADT message payload converted to XML"
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
