running a procedure that's part of a package through concurrent manager [message #175834] |
Mon, 05 June 2006 11:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rbertrand
Messages: 45 Registered: November 2005
|
Member |
|
|
I have a package, lgmc _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.
-
Attachment: pic1.bmp
(Size: 621.92KB, Downloaded 3893 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
The first two parameters to get_keyflex_id need to beerrbuf 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|