Home » SQL & PL/SQL » SQL & PL/SQL » pls 00103 error (11g,toad 12.1)
pls 00103 error [message #610452] |
Thu, 20 March 2014 03:25 |
|
ashwanth77
Messages: 95 Registered: April 2013 Location: India
|
Member |
|
|
when i execute the below proc from sqlplus it throws me
declare
c SYS_REFCURSOR;
err_code VARCHAR2(50);
err_messge VARCHAR2(50);
begin
exec sp_dr_save_internal_initiation('402133',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,c,e rr_code ,err_messge );
end;
/
ERROR at line 6:
ORA-06550: line 6, column 6:
PLS-00103: Encountered the symbol "SP_DR_SAVE_INTERNAL_INITIATION" when
expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "SP_DR_SAVE_INTERNAL_INITIATION" to
continue.
i trie by using bind variable like :c,:err_code,:err_messge but that dint help either
procedure with variables
CREATE OR REPLACE PROCEDURE SUPPLIER.Sp_Dr_Save_Internal_Initiation (
iv_scdr_id IN VARCHAR2,
iv_issue_category IN VARCHAR2,
iv_priority IN VARCHAR2,
iv_order_number IN VARCHAR2,
iv_customer_po IN VARCHAR2,
iv_vehicle_type IN VARCHAR2,
iv_vehicle_number IN VARCHAR2,
iv_haulier IN VARCHAR2,
iv_ship_from_code IN VARCHAR2,
iv_shipto_cust_id IN VARCHAR2,
iv_ship_date IN VARCHAR2,
iv_sc_id IN VARCHAR2,
iv_account_exec IN VARCHAR2,
iv_lane_contracted IN VARCHAR2,
iv_emergency_order IN VARCHAR2,
iv_return_order IN VARCHAR2,
IV_ACTUAL_VALUE IN VARCHAR2,
IV_CORRECTED_VALUE IN VARCHAR2,
iv_mod_id IN VARCHAR2,
--iv_flag IN VARCHAR2,
out_scdr OUT NOCOPY SYS_REFCURSOR,
ov_err_code OUT NOCOPY VARCHAR2,
ov_err_messge OUT NOCOPY VARCHAR2
)
|
|
|
Re: pls 00103 error [message #610453 is a reply to message #610452] |
Thu, 20 March 2014 03:31 |
|
ashwanth77
Messages: 95 Registered: April 2013 Location: India
|
Member |
|
|
when i execute with bind variables this what i get
declare
c SYS_REFCURSOR;
err_code VARCHAR2(50);
err_messge VARCHAR2(50);
begin
exec sp_dr_save_internal_initiation('402133',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,:c, :err_code ,:err_messge );
end;
/
SP2-0552: Bind variable "ERR_MESSGE" not declared.
[Updated on: Thu, 20 March 2014 03:32] Report message to a moderator
|
|
|
Re: pls 00103 error [message #610456 is a reply to message #610453] |
Thu, 20 March 2014 04:01 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Exec is a sqlplus command. It takes the stored procedure call that follows it and wraps it in a begin/end block. You can not use it, and do not need it, in a PL/SQL block. So just remove it.
Also all pl/sql variables are treated as binds automatically. In the above example c is not the same as :c. Remove the colons as well.
|
|
|
|
Goto Forum:
Current Time: Wed Apr 24 08:16:19 CDT 2024
|