0 registered members (),
3
guests, and
12
spiders. |
Key:
Admin,
Global Mod,
Mod
|
|
|
#3406 - 27/07/08 12:55 PM
CREATE_GRADE api returns:PLS-00306: wrong number o
|
Joined: May 2008
Posts: 82
tovia123
hacker
|
hacker
Joined: May 2008
Posts: 82
UK
|
Hi I have created a package to load grades information as per code: http://pastebin.com/m57c2146fData in my temporary table(currently loading 1st record only for testing!): http://pastebin.com/m681542e3The data in my table in sql : Name Null? Type ----------------------------------------- -------- ----- SEQUENCE NUMBER NAME VARCHAR2(70) HEALTHCARE_SERVICE VARCHAR2(80) DEATH_SERVICE VARCHAR2(70) LONG_DISABILITY VARCHAR2(70) MOBILE_PHONE VARCHAR2(5) HOLIDAY_ENTITLEMENT NUMBER(5) STD_PROBATION NUMBER(5) STD_NOTICE NUMBER(5) REPORTED_AS VARCHAR2(30) PAYCODE VARCHAR2(5) INCENTIVE_SCHEME VARCHAR2(20) FLEX_BENEFIT VARCHAR2(20) Also: I have removed all the value sets for the descriptive flexfield under: Application > flexfield > Descriptive > segments and i have successfully inserted the record manually by cutting and pasting field values from my data file! So in SQL*PLUS: Why does it still complain of this: Problem: I am getting error: LINE/COL ERROR ----------------------------------------------------------------- 71/1 PLS-00306: wrong number or types of arguments in call to 'CREATE_GRADE' I went to line 71 within the file in notepad and i didnt find anything i am confused. Thanks in advance Tovia singer
|
|
|
#3408 - 28/07/08 08:14 AM
Re: CREATE_GRADE api returns:PLS-00306: wrong numb
[Re: CT]
|
Joined: May 2008
Posts: 82
tovia123
hacker
|
hacker
Joined: May 2008
Posts: 82
UK
|
HI CT Thanks so much I added p_grade_id:=v_grade_id; and it compiled successfull but didnt create any records, so i checked the commit, and it was in the place same place as in my jobs api call. Also checked the application and there where no grades so it shouldnt have any problem loading them. My data file is: http://pastebin.com/m2bce6d4aThere should be an error if it doesnt load the data i dont understand! Thanks in advance Tovia Singer
|
|
|
#3410 - 28/07/08 12:21 PM
Re: CREATE_GRADE api returns:PLS-00306: wrong numb
[Re: CT]
|
Joined: May 2008
Posts: 82
tovia123
hacker
|
hacker
Joined: May 2008
Posts: 82
UK
|
Hi CT Basically i set serverouput on: set serveroutput on size 20000; But i still get the following output: SQL> @XXcompany_INT_GRADES_LOAD Package created. No errors. Package body created. No errors. The revised code with p_grade_id: http://pastebin.com/m5fc0c461Thanks in advance Tovia
|
|
|
#3412 - 28/07/08 01:17 PM
Re: CREATE_GRADE api returns:PLS-00306: wrong numb
[Re: CT]
|
Joined: May 2008
Posts: 82
tovia123
hacker
|
hacker
Joined: May 2008
Posts: 82
UK
|
HI CT
Sorry:
SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRADES; Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:, Ex:,
PL/SQL procedure successfully completed.
And it doesnt actually load any data,
Thanks in advance
Tovia S
|
|
|
#3414 - 28/07/08 06:04 PM
Re: CREATE_GRADE api returns:PLS-00306: wrong numb
[Re: CT]
|
Joined: May 2008
Posts: 82
tovia123
hacker
|
hacker
Joined: May 2008
Posts: 82
UK
|
Hi CT Sorry for the delay in feedback, I did as you said above: Latest code: http://pastebin.com/m2c1dff1dThe feedback from/ error in sql: SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRA Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, Ex:, -20001ORA-20001: FLEX-ID DOES NOT EXIST: Ex:, PL/SQL procedure successfully completed. SQL> Thanks in advance Tovia Singer
|
|
|
|
Forums60
Topics2,233
Posts12,046
Members1,321
|
Most Online283 Dec 25th, 2019
|
|
|
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
|
|
|
|
|
|
|
|