Error when a package don't use in PL/SQL script. [message #2382] |
Wed, 10 July 2002 07:45 |
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 |
|
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
|
|
|