vamsi kasina Messages: 1597 Registered: October 2003 Location: Hyderabad, India
Senior Member
Which package?
Is your concurrent program having an executable as "Stored Procedure"?
What is the signature of the procedure?
What are the values you are passing as the parameters to the concurrent program?
vamsi kasina Messages: 1597 Registered: October 2003 Location: Hyderabad, India
Senior Member
When you expect answer from others, you also have to answer all the questions asked by them.
Quote:
What is the signature of the procedure?
Anyway, have a look at the chapter "PL/SQL APIs for Concurrent Processing" in Oracle Applications Developer's Guide. I suspect that, you haven't defined the signature correctly with errbuf and retcode.
kecd_deepak Messages: 52 Registered: December 2007
Member
Hi..
Hey what are you doing.........in your code...
What about your Approach.......
=> No log messages......
=> l_object_version_number : you are using same variable twice....
first u populate it with object_version_number from per_all_assignments_f
and then u overrite it with object_version_number from per_all_people_f.
Please provide bject_version_number selected from per_all_assignments_f to the API.
This cause the ERROR.
use this
SELECT assignment_id
,MAX(object_version_number)
INTO lv_assignment_id
,lv_assg_obj_ver_num
FROM per_all_assignments_f
WHERE 1=1
AND person_id = lv_person_id
GROUP BY assignment_id;
] 
Members
Search
Help
Register
Login
Home
