Home » SQL & PL/SQL » SQL & PL/SQL » Error compiling in 10g
Error compiling in 10g [message #203601] Wed, 15 November 2006 13:51 Go to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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 Go to previous message
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.
Previous Topic: ora-01426 numeric overflow
Next Topic: export `create table`, 'insert into`...
Goto Forum:
  


Current Time: Tue Dec 06 06:10:24 CST 2016

Total time taken to generate the page: 0.05500 seconds