Home » Applications » Oracle Fusion Apps & E-Business Suite » Registering PL/SQL procedure
Registering PL/SQL procedure [message #224629] Wed, 14 March 2007 19:07 Go to next message
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.

Report message to a moderator

Re: Registering PL/SQL procedure [message #224777 is a reply to message #224629] Thu, 15 March 2007 07:51 Go to previous messageGo to next message
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

Report message to a moderator

Re: Registering PL/SQL procedure [message #224806 is a reply to message #224777] Thu, 15 March 2007 09:39 Go to previous messageGo to next message
pbills
Messages: 40
Registered: February 2007
Member
What does creating executable for stored procedure means.

How about the out/put file.

How I have to declare in my procedure.


Thanks

Report message to a moderator

Re: Registering PL/SQL procedure [message #224810 is a reply to message #224806] Thu, 15 March 2007 10:14 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
here you go.

follow link

Report message to a moderator

Re: Registering PL/SQL procedure [message #224811 is a reply to message #224810] Thu, 15 March 2007 10:19 Go to previous messageGo to next message
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.

Report message to a moderator

Re: Registering PL/SQL procedure [message #224936 is a reply to message #224811] Fri, 16 March 2007 01:04 Go to previous messageGo to next message
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

Report message to a moderator

Re: Registering PL/SQL procedure [message #224989 is a reply to message #224936] Fri, 16 March 2007 07:11 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
looks like some procedure error. better check metalink for this.

Report message to a moderator

Re: Registering PL/SQL procedure [message #225010 is a reply to message #224936] Fri, 16 March 2007 09:53 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
By the way what is PAYMENT_REGISTER1?
Procedure name? (Or) Any variable name in the procedure?
If it is procedure name, cross check the privileges.

By
Vamsi

Report message to a moderator

Re: Registering PL/SQL procedure [message #225033 is a reply to message #225010] Fri, 16 March 2007 12:02 Go to previous messageGo to next message
pbills
Messages: 40
Registered: February 2007
Member
PAYMENT_REGISTER1 is the procedure name.


SAtatus in the table for this procedure says VALID.


Thanks

Report message to a moderator

Re: Registering PL/SQL procedure [message #225092 is a reply to message #225033] Sat, 17 March 2007 05:27 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I hope I didn't tell you to check the validity of the procedure.
But that is also a good idea.
Quote:
cross check the privileges
By
Vamsi

Report message to a moderator

Re: Registering PL/SQL procedure [message #225326 is a reply to message #225092] Mon, 19 March 2007 12:58 Go to previous message
pbills
Messages: 40
Registered: February 2007
Member
Hello Vamsi,

Your guess was correct The procedure I created doesn't have enough privilages.

I granted the access.

Now it is working

Thanks.

Report message to a moderator

Previous Topic: Tax should be applied on original amount not the discount
Next Topic: Aging 4 bucket to 6 bucket
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 16:55:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.