Registering PL/SQL procedure [message #224629] |
Wed, 14 March 2007 19:07 |
pbills
Messages: 40 Registered: February 2007
|
Member |
|
|
Hello,
I created a procedure.
1.Do i need to save it as '.prc' or'.sql'
2.how to execute a procedure it has three in parameters
3.how to concurrent procedure in apps.
|
|
|
Re: Registering PL/SQL procedure [message #224777 is a reply to message #224629] |
Thu, 15 March 2007 07:51 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
do the following for procedure
Create a procedure with first two parameter being
err_mesg and err_code. These two are required for oracle application to user PL/SQL executable.
so from parameter 3 on wards you can have your concurrent program parameter. i.e. parameter 3 of Procedure is parameter 1 of your concurrent program
do the following for registering concurrent program
1) Create a procedure in your application
2) Create an executable of PL/SQL stored procedure
3) for that executable create a concurrent program
regards
Prashant Pathak
|
|
|
|
|
Re: Registering PL/SQL procedure [message #224811 is a reply to message #224810] |
Thu, 15 March 2007 10:19 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
regarding creating procedure.
create or replace procedure_name (err_mesg OUT varchar2,err_code OUT number,para1 , para2)
Just use apps user compile your procedure.
in executable just give the name of procedure not prc or sql. just database object name of your procedure.
regarding your log/out EBS will take care of it.
|
|
|
Re: Registering PL/SQL procedure [message #224936 is a reply to message #224811] |
Fri, 16 March 2007 01:04 |
pbills
Messages: 40 Registered: February 2007
|
Member |
|
|
I created the procedure.In toad it doest not show any error. From apps
Cause: FDPSTP failed due to ORA-06550: line 1, column 7: PLS-00201: identifier 'PAYMENT_REGISTER1' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
I used err_mesg OUT varchar2,err_code OUT number
Concurrenting looks fine
I can see my procedure in schema in toad.
I executed the same program from developing instance it worked and also got o/p file from apps.
Thanks
Pallavi
|
|
|
|
|
|
|
|