No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

How to consume pa_schedule_pub.populate_work_pattern_table?
Next thread: Report - DBA and Apps DBA
Prev thread: profile.XML with mdns daemeon

Message Score Author Date
Hello Oracle developers. Newbie PL/SQL dev here. I...... Jen Inigo Jul 26, 2018, 11:06
Hello Jen, probably not related, but what about...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Bruno Vroman Jul 30, 2018, 12:38

Follow up by mail Click here


Subject: How to consume pa_schedule_pub.populate_work_pattern_table?
Author: Jen Inigo, Philippines
Date: Jul 26, 2018, 11:06, 87 days ago
Error info: wrong number or type of arguments in call to 'populate_work_pattern_table'.
Message: Hello Oracle developers. Newbie PL/SQL dev here. I'm not sure if this is the proper venue to ask. But I'll ask this anyway. Hopefully someone can help.



We are creating a POC on this API: pa_schedule_pub.populate_work_pattern_table. We already created a anonymous script, and called the API



pa_schedule_pub.populate_work_pattern_table (

p_resource_id_tbl => ra_person_id,

p_assgn_range_start_date => ra_start_date,

p_assgn_range_end_date => '1/31/2023' , -

p_display_start_date => gd_sysdate ,

p_status_code => NULL ,

p_delete_flag => 'Y' ,

x_show_start_date => ld_msg_show_start_date ,

x_return_status => lv_out ,

x_msg_count => ln_msg_count ,

x_msg_data => lv_msg_data);



But it rendered this error: wrong number or type of arguments in call to 'populate_work_pattern_table'.

I suspect the error is on p_resource_id_tbl, as I passed a value here based on my SELECT statement and the datatype is number.

Can you please help me on how to properly consume this api? Thank you in advance.



This is the API signature:

PROCEDURE Populate_work_pattern_table (

p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

p_assgn_range_start_date IN DATE := NULL ,

p_assgn_range_end_date IN DATE := NULL ,

p_display_start_date IN DATE ,

p_status_code IN VARCHAR2 := NULL ,

p_delete_flag IN VARCHAR2 := 'Y' ,

x_show_start_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895

x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

x_msg_data OUT NOCOPY VARCHAR2)

This is the declaration of the passed parameters..


lv_out VARCHAR2(1000);

ln_msg_count NUMBER;

lv_msg_data VARCHAR2(2000);

lv_error_message VARCHAR2(2000);

ln_error_count NUMBER := 0;

lv_data_txt VARCHAR2(1000);

ln_msg_index_num NUMBER;

ld_msg_show_start_date DATE;

gd_sysdate DATE := SYSDATE;

ra_person_id pa_resource_assignments.person_id%ROWTYPE;

ra_start_date pa_resource_assignments.planning_start_date%ROWTYPE;

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to consume pa_schedule_pub.populate_work_pattern_table?
Author: Bruno Vroman, Belgium
Date: Jul 30, 2018, 12:38, 83 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hello Jen,

probably not related, but what about p_assgn_range_end_date => '1/31/2023'? You pass a string where a date is expected, relying on the session default date format... Avoid implicit conversion by either using explicit conversion:
   p_assgn_range_end_date => TO_DATE( '01/31/2023', 'MM/DD/YYYY' )
or using the ISO format for a date constant: keyword DATE and value in format YYYY-MM-DD:
   p_assgn_range_end_date => DATE '2023-01-31'

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here