[VIEWED 2833
TIMES]
|
SAVE! for ease of future access.
|
|
|
dongdong
Please log in to subscribe to dongdong's postings.
Posted on 08-21-07 1:45
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
i need some help with store procedure
|
|
|
|
dongdong
Please log in to subscribe to dongdong's postings.
Posted on 08-21-07 1:51
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
when i compile in toad it work, it execute without error but when i tried in sql plus it give me this error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to ORA-06550: line 1, column 7: PL/SQL: Statement ignored thanks in advance
|
|
|
gurkha's
Please log in to subscribe to gurkha's's postings.
Posted on 08-21-07 2:15
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 08-21-07 4:01
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
PLS-00306: wrong number or types of arguments in call to ..... can u type what was after above error message
|
|
|
dongdong
Please log in to subscribe to dongdong's postings.
Posted on 08-21-07 4:04
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
SQL> exec upadd; BEGIN upadd; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPADD' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 08-21-07 4:32
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
PDATE fincl_rltd_hist SET fincl_rltd_end_dt =trunc(SYSDATE+1), -- sysdate, lst_updt_by = incuid, updt_dt = SYSDATE, approval_id = v_id1, rec_status = 'P' WHERE prim_fincl_id = infincl_id AND fincl_rltd_rsn_cd = inreason_cd AND fincl_rltd_end_dt = (SELECT MAX (fincl_rltd_end_dt) FROM fincl_rltd_hist WHERE prim_fincl_id = infincl_id); dont you have to close that Parenthesis. this is pretty long proc. requires some time
|
|