Home » SQL & PL/SQL » SQL & PL/SQL » SP2-0158: unknown SET option "message" (Oracle 10g)
SP2-0158: unknown SET option "message" [message #359607] Mon, 17 November 2008 10:13 Go to next message
tommyb
Messages: 2
Registered: November 2008
Junior Member
We do an upgrade from 9i to 10g and we got trouble with a pl/sql custom procedure, the set message off isn't supported anymore in 10G.

I would like to know if something else replace it. I checked in 10g documentation and on metalink but I found nothing about that, maybe someone here gonna be able to help me


The error: SP2-0158: unknown SET option "message"

This is my code:

SET message off;
set echo off;
set feedback off;
set heading off;
set numwidth 4;
proMPt;
spool ./tmp/inject_report.sqltmp;
--
-- A normaliser
--
select ' '||substr(item_value,1,11)||':',count(*),
'Guichet traiter'
from dj_load_queryvpd
where queryvpd_no > (select queryvpd_next_no from dj_load_queryvpd_control)
and sub_section_name = 'Date of report'
and local_inv_asset_tag like '@%'
group by item_value
union all
select ' '||substr(item_value,1,11)||':', count(*),
'Serveur traiter'
from dj_load_queryvpd
where queryvpd_no > (select queryvpd_next_no from dj_load_queryvpd_control)
and sub_section_name = 'Date of report'
and local_inv_asset_tag not like '@%'
and length(rtrim(local_inv_asset_tag)) = 7
group by item_value
union all
select ' '||substr(item_value,1,11)||':', count(*),
'Poste traiter'
from dj_load_queryvpd
where queryvpd_no > (select queryvpd_next_no from dj_load_queryvpd_control)
and sub_section_name = 'Date of report'
and local_inv_asset_tag not like '@%'
and length(rtrim(local_inv_asset_tag)) <> 7
group by item_value
union all
select ' '||substr(to_char(date_of_report,'yyyy-mm-dd'),1,11)||':',
count(*),
'Guichet traiter'
from dj_local_inventory
where local_inv_status_id = 1
and local_inv_asset_tag like '@%'
group by date_of_report
union all
select ' '||substr(to_char(date_of_report,'yyyy-mm-dd'),1,11)||':',
count(*),
'Serveur traiter'
from dj_local_inventory
where local_inv_status_id = 1
and local_inv_asset_tag not like '@%'
and length(rtrim(local_inv_asset_tag)) = 7
group by date_of_report
union all
select ' '||substr(to_char(date_of_report,'yyyy-mm-dd'),1,11)||':',
count(*),
'Poste traiter'
from dj_local_inventory a
where local_inv_status_id = 1
and local_inv_asset_tag not like '@%'
and length(rtrim(local_inv_asset_tag)) <> 7
and not exists (select 1 from dj_load_queryvpd b
where b.local_inv_asset_tag = a.local_inv_asset_tag)
group by date_of_report
order by 2,1;
exit;

Regards,
Tommy
DBA

[Updated on: Mon, 17 November 2008 10:18]

Report message to a moderator

Re: SP2-0158: unknown SET option "message" [message #359612 is a reply to message #359607] Mon, 17 November 2008 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I cheked in 8.1.7, 9.2 and 10.2 documentation this option is mentioned nowhere.
I checked in database:
SQL> set message off
SP2-0158: unknown SET option "message"
SQL> @v

Version Oracle : 9.2.0.8.0

SQL> set message off
SQL> @v

Version Oracle : 8.1.7.4.1

It indeed works in 8.1.7.
So now what was its purpose?

Regards
Michel
Re: SP2-0158: unknown SET option "message" [message #359614 is a reply to message #359612] Mon, 17 November 2008 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I checked it was neither in 7.3.4 documentation.

Regards
Michel
Re: SP2-0158: unknown SET option "message" [message #359621 is a reply to message #359612] Mon, 17 November 2008 12:07 Go to previous message
tommyb
Messages: 2
Registered: November 2008
Junior Member
That's what I found on a website:
set message=off
{*Turn off warning messages.*}
but it's not specified which one.

I guess we will just remove this from our code
It should not impact anything since it's not documented anywhere

Thank you for your help.

Previous Topic: Rebuild index
Next Topic: where condition based on column value
Goto Forum:
  


Current Time: Sat Dec 10 12:57:36 CST 2016

Total time taken to generate the page: 0.07897 seconds