| Error compiling in 10g [message #203601] |
Wed, 15 November 2006 13:51  |
vimal1234
Messages: 12
Registered: November 2006
|
Junior Member |
|
|
Hello experts,
Recently we upgraded from Oracle 9i to Oracle 10g. When I try to compile one of the package it threw following errors. It was running fine on Oracle 9i. Please help!!!
PACKAGE PIECE:
nsc_v.g_control_total_inserted := 0;
nsc_v.g_control_total_processed := 0;
nsc_v.g_control_total_read := 0;
begin
v_regn_cd := nsc_v.g_parameter(k_region);
exception
when others then
dbms_output.put_line(' region parameter not found
, calling get_parameter ');
v_regn_cd := nsc_utilities.get_parameter(k_region);
end;
begin
v_active_flag := nsc_v.g_parameter(k_active_flag);
exception
when others then
dbms_output.put_line(' active flag parameter not found
, calling get_parameter ');
v_active_flag := nsc_utilities.get_parameter(k_active_flag);
end;
ERROR GOT:
(1): PLS-00371: at most one declaration for 'NSC_V.G_PARAMETER' is permitted
(2): PL/SQL: Statement ignored
(3): PLS-00371: at most one declaration for 'NSC_V.G_PARAMETER' is permitted
(4): PL/SQL: Statement ignored
Pease help!!!
Vimal
|
|
|
|
| Re: Error compiling in 10g [message #203669 is a reply to message #203601] |
Thu, 16 November 2006 00:24  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
|
This is not the right snippet. You have declared NSC_V.G_PARAMETER more than once in your package, so you will have to search for the declaration of that.
|
|
|
|
| Re: Error compiling in 10g [message #203703 is a reply to message #203669] |
Thu, 16 November 2006 01:44 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I suspect that it might be the lines nsc_v.g_control_total_inserted := 0;
nsc_v.g_control_total_processed := 0;
nsc_v.g_control_total_read := 0;
They look from the partial code pasted like they're in the DECLARE section.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
