Home » Applications » Oracle Fusion Apps & E-Business Suite » running a procedure that's part of a package through concurrent manager
running a procedure that's part of a package through concurrent manager [message #175834] Mon, 05 June 2006 11:35 Go to next message
rbertrand
Messages: 45
Registered: November 2005
Member
I have a package, lgmc/forum/fa/1160/0/_pay_element_post that contains several procedures. I'm having trouble getting the procedures to run, I keep getting the following eror:


Oracle Payroll: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

LGMC_GET_KEYFLEX_ID module: lgmc_get_keyflex_id
+---------------------------------------------------------------------------+

Current system time is 05-JUN-2006 11:01:08

+---------------------------------------------------------------------------+

**Starts**05-JUN-2006 11:01:08
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_KEYFLEX_ID'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


The spec for the procedure looks like this:

PROCEDURE get_keyflex_id (
x_keyflex OUT NUMBER,
x_error_flag OUT BOOLEAN,
p_company IN LGMC_PAY_ELEMENT_STG.COMPANY%TYPE,
p_org IN LGMC_PAY_ELEMENT_STG.ORG%TYPE
);




I've also attached my concurrent program definition.

/forum/fa/1160/0/
  • Attachment: pic1.bmp
    (Size: 621.92KB, Downloaded 3953 times)
Re: running a procedure that's part of a package through concurrent manager [message #175835 is a reply to message #175834] Mon, 05 June 2006 12:02 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
The first two parameters to get_keyflex_id need to be
errbuf     OUT  VARCHAR2
retcode    OUT  VARCHAR2
You really must read the Oracle Applications Developer's Guide [Part Number A75545-03].

In it, you will find this quote:
Quote from the Oracle Applications Developer's Guide, pp.15-12 to 15-13:

Following is an example specification of a PL/SQL procedure you could create to run
as a concurrent program:
REM /* Beginning of SQL Script */
REM
CREATE PROCEDURE FND60.SAMPLE_PROC (
ERRBUF OUT VARCHAR2,
RETCODE OUT VARCHAR2,
ARGUMENT1 IN VARCHAR2,
ARGUMENT2 IN VARCHAR2,
ARGUMENT3 IN VARCHAR2,
.
.
.
.
ARGUMENT100 IN VARCHAR2,
)
Your stored procedure concurrent program is restricted to 100 parameters in addition to the first two parameters, which are required and must be specified exactly as indicated in the example above. (You must take these two parameters into account when you create your stored procedure.) Use errbuf to return any error messages, and retcode to return completion status. The parameter retcode returns 0 for success, 1 for success with warnings, and 2 for error. After your concurrent program runs, the concurrent manager writes the contents of both errbuf and retcode to the log file associated with your concurrent request.
Re: running a procedure that's part of a package through concurrent manager [message #199423 is a reply to message #175835] Tue, 24 October 2006 03:51 Go to previous messageGo to next message
yanfuju_1979
Messages: 42
Registered: October 2006
Member
dear Art Metzer ,
i want to know more detail about this topic for i also tring to create concurrent program of PL/SQL Stored Porcedure.
i do what you suggest in my package procedure add
the two parameters:
ERRBUF OUT VARCHAR2,
RETCODE OUT VARCHAR2,
but i still can not run it ,the same error accured like
-------------------------------------
**Starts**24-OCT-2006 16:13:22
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INSERT_ANALYSIS_DATA'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

----------------------------------
i also reference the developer user guid to restart standard manager. but error still happen.

i want you give some detail setps on how to do .
i also want you send your idea to my e-mail : yanfuju_1979@hotmail.com


best regards
JILL yan
trouble in install printer [message #201808 is a reply to message #175835] Mon, 06 November 2006 20:08 Go to previous message
yanfuju_1979
Messages: 42
Registered: October 2006
Member
dear sir,

i have trouble in install printer which can be select when submit oracle report.
urgent please . i wish you can help me like before!


Regards
JILL
Previous Topic: Oracle iProcurement
Next Topic: adding a new user to the financial app as a sys admin
Goto Forum:
  


Current Time: Tue Dec 24 11:56:30 CST 2024