| Procedure Help [message #370150] |
Fri, 22 December 2000 07:51  |
Ralphie
Messages: 14
Registered: October 2000
|
Junior Member |
|
|
Running Oracle 8.1.5 this procedure is entered and works great:
create or replace procedure gen_next_id (seq_name char, seq_val out number) as
begin
update lm_next_id
set next_val = next_val + 1
where id = seq_name
returning next_val into seq_val;
end gen_next_id;
/
In Oracle 8.1.6 when entering the same procedure I get this error:
create or replace procedure gen_next_id as
*
ERROR at line 1:
ORA-06541: PL/SQL: compilation error - compilation aborted
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this release
Can anyone help me understand why?
|
|
|
|
| Re: Procedure Help [message #370169 is a reply to message #370150] |
Tue, 26 December 2000 23:57  |
amarpatgiri
Messages: 11
Registered: December 2000
|
Junior Member |
|
|
The problem is NOT with your pl/sql code, but with the SYS.STANDARD package. Please check the status of this package and if necessary recompile the package. One more piece of info if you upgraded from 8.1.5 to 8.1.6 - you need to run u0801050.sql.
Hope this helps :-)
-amar
|
|
|
|
| Re: Procedure Help [message #370177 is a reply to message #370150] |
Thu, 28 December 2000 09:29 |
Ralphie
Messages: 14
Registered: October 2000
|
Junior Member |
|
|
Thanks. I completely forgot to run my patches for Oracle 8.1.6. It was an upgrade so this was the fix I was looking for. Sometimes you just need a fresh pair of eyes to look at the situation.
Thanks so much,
Chris
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
