Errors after upgrading to 10.2.0.3

[malaygal]

I just recently upgraded our Oracle database and my Oracle client to 10.2.0.3.0.
Now I am getting errors that I have not encountered prior to upgrade (from 10.2.0.0).

First on SQL Plus, I tried to run a sql file (select) and I get either SP2-0024 Nothing to Save or SP2-0023 String Not Found.

Secondly, when I tried to compile a stored procedure I get a warning (did it compile) PLW-07204.


p_Loc_ID NUMBER(8);
p_Loc_Name Varchar2,

Select loc_ID ('this is the line getting the error)
into p_Loc_ID
from Location
where upper(loc_name) = p_Loc_Name;


loc_ID and loc_name from Location table are the same datatype as p_loc_ID and p_Loc_Name resp.


Any help will be greatly appreciated.

 

[SantaMufasa]

Malaygal,

The errors, "SP2-0024" and "SP2-0023" are SQL*Plus errors relating, typically, to errors that SQL*Plus encountered while manipulating its SQL command buffer. They indicate benign issues with not being able to properly execute SQL*Plus buffer-editing commands. So I wouldn't worry too much, at this point, about those diagnostics. (We can troubleshoot those issues later if they persist.)

Next...

Without more/better context to evaluate your code, I must presume that your PL/SQL code is syntactically problematic:

...p_Loc_Name  Varchar2,...

Unless p_loc_name is an argument for a procedure or function, "Varchar2", without a length specification, is syntactically illegal. Unless your code is gigantic, could you please post your complete set of code from "CREATE OR REPLACE..." down to "END;"?

Also, to help us help you, could you please post the results of running "DESCRIBE location" so we can see the column definitions of the LOCATION table?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]