Thursday 27 December 2012

Question: What are the different types of scripts/programs that can be attached to concurrent programs?

A sql script

 Sql*Loader program

Java program

Oracle Report

Pl/SQL program ( or call it a stored procedure/package procedure)Host script,

 like a unix shell script

Pro*C/Spawned

Perl


1. Create a table and a stored procedure in pl/sql
create table xx_hello_world_tab
(
 message_text VARCHAR2(
100)
,creation_date DATE
) ;

CREATE OR REPLACE PROCEDURE
xx_register_user_prc(errbuf      OUT VARCHAR2,retcode     OUT VARCHAR2IS
BEGIN
  INSERT INTO xx_hello_world_tab VALUES (
'Hello World' ,SYSDATE);
END xx_register_user_prc;

SELECT * FROM xx_hello_world_tab ;

--Zero records will be returned here

2. Note the two parameters, namely errbuff and retcode
These parameters for used for the interaction between the concurrent program and the pl/sql Program. I suggest to the beginners not to spend much time on these parameters.

3. Define an executable attached to this procedure.
This can be done by navigating to the responsibility “Application Developer”, and selecting the menu /Concurrent/Executable
Image

4. Define the concurrent program
This can be done by navigating to responsibility “Application Developer” and then selecting menu /Concurrent/Program
Image

5. Attach this program to a report group.Go to System Administrator responsibility, and select
/Security/Responsibility/Request
Image

Now, we can navigate to the Receivables Manager and submit the concurrent request.
Image
After the completion of the request, we check the table
Image

No comments:

Post a Comment