| SP2-0158: unknown SET option "message" [message #359607] |
Mon, 17 November 2008 10:13  |
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 #359621 is a reply to message #359612] |
Mon, 17 November 2008 12:07  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
