Home » SQL & PL/SQL » SQL & PL/SQL » Error when a package don't use in PL/SQL script.
Error when a package don't use in PL/SQL script. [message #2382] Wed, 10 July 2002 07:45 Go to next message
yves rochelle
Messages: 1
Registered: July 2002
Junior Member
I want to execute a different Package for the statistics between the 8 and 8i Oracle version.
so i wrote this script PL/SQL. But when the package doesn't exist (on 8), i have an error with the package of 8i ?? But with the test (if) i shouldn't have this error. Have you an idea ?

connect &2./&3.@&1.
set echo on
set timing on
set verify off
variable Vers char;
declare
begin
if substr(&_O_RELEASE,1,3) = 800 then
:Vers:='8';
dbms_utility.analyze_schema('&2.','ESTIMATE',&4.);
else
:Vers:='8i';
dbms_stats.gather_schema_stats('&2.',&4.,cascade => true);
end if;
end;
/
print Vers
QUIT;
Re: Error when a package don't use in PL/SQL script. [message #2386 is a reply to message #2382] Wed, 10 July 2002 10:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
define the vers as char(10)
SQL> @1
SQL> connect &2./&3.@&1.
Enter value for 2: mag
Enter value for 3: mag
Enter value for 1: rdtest
Connected.
SQL> set echo on
SQL> set timing on
SQL> set verify off
SQL> variable Vers char(10);
SQL> declare
  2  begin
  3  if substr(&_O_RELEASE,1,3) = 800 then
  4  :Vers:='8';
  5  dbms_utility.analyze_schema('&2.','ESTIMATE',&4.);
  6  else
  7  :Vers:='8i';
  8  dbms_stats.gather_schema_stats('&2.',&4.,cascade => true);
  9  end if;
 10  end;
 11  /
Enter value for 2: mag
Enter value for 4: 10
Enter value for 2: mag
Enter value for 4: 10

PL/SQL procedure successfully completed.

Elapsed: 00:00:05.89
SQL> Input truncated to 10 characters
print Vers

VERS
--------------------------------
8i

Previous Topic: SQL LOADER
Next Topic: sql question
Goto Forum:
  


Current Time: Thu Mar 28 16:23:23 CDT 2024