Home » Developer & Programmer » Reports & Discoverer » SRW.MESSAGE
SRW.MESSAGE [message #286388] Fri, 07 December 2007 04:31 Go to next message
sriramn1
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
HI,

How do i handle the following built-in procedure (oracle Reports) in to PL/SQL Procedure.

SRW.MESSAGE(msg_number NUMBER, msg_text CHAR);

Pls reply immediatly.

NSR
Re: SRW.MESSAGE [message #286389 is a reply to message #286388] Fri, 07 December 2007 04:32 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Outside Reports? You can't.

MHE
Re: SRW.MESSAGE [message #286391 is a reply to message #286388] Fri, 07 December 2007 04:35 Go to previous messageGo to next message
sriramn1
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
Hi,

How to handle in PL/SQL stored procedure.Not out side Reports.

Pls Help.

NSR
Re: SRW.MESSAGE [message #286392 is a reply to message #286388] Fri, 07 December 2007 04:39 Go to previous messageGo to next message
sriramn1
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
HI ,

Can any one help ,How do I handle SRW.MESSAGE in PL/SQL stored procedure Block. I am getting compilation error.

Help me.

NSR
Re: SRW.MESSAGE [message #286394 is a reply to message #286392] Fri, 07 December 2007 04:42 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What error? Besides, what reports version are you working with?

MHE
Re: SRW.MESSAGE [message #286397 is a reply to message #286392] Fri, 07 December 2007 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sriramn1

How do I handle SRW.MESSAGE in PL/SQL stored procedure
Stored procedure is stored in a database. SRW package is used in Reports Builder. Stored procedure can not see it (i.e. you can not use it there).

Reports Builder Online Help System

You can reference the contents of the SRW package from any of your libraries or reports without having to attach it. However, you cannot reference its contents from within another product, e.g., from SQL*Plus.
Re: SRW.MESSAGE [message #286417 is a reply to message #286394] Fri, 07 December 2007 05:37 Go to previous messageGo to next message
sriramn1
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member
Hi,

Working with oracle 9i reports.

PLS-00201: identifier 'SRW.MESSAGE' must be declared.

NSR
Re: SRW.MESSAGE [message #286431 is a reply to message #286394] Fri, 07 December 2007 06:15 Go to previous messageGo to next message
sriramn1
Messages: 5
Registered: November 2007
Location: Hyderabad
Junior Member

HI,

ERROR: PLS-00201: identifier 'SRW.MESSAGE' must be declared

The code is....

function CF_pl__addrFormula(
i_residence_txt IN varchar2,
i_residence_note IN varchar2) return VARCHAR2 is
pl_addr VARCHAR2(200);
begin
SELECT line1||DECODE(line2,NULL,NULL,' '||line2)||' '||town||' '||state INTO pl_addr
FROM party_legal_address
WHERE cs_fl_case = i_case
AND cs_prty_seq = 1
AND seq = (SELECT MAX(seq) FROM party_legal_address
WHERE cs_fl_case = i_case
AND cs_prty_seq = 1
AND adminvoid_date IS NULL
AND seal_ind = i_seal_flag)
AND adminvoid_date IS NULL
AND seal_ind = i_seal_flag;
srw.message(1,pl_addr);
IF pl_addr IS NOT NULL THEN
RETURN(i_residence_txt||' '||pl_addr||' '||i_residence_note);
ELSE
RETURN(i_residence_txt||' '||i_residence_note);
END IF;
EXCEPTION
WHEN OTHERS THEN
RETURN(i_residence_txt||' '||i_residence_note);
end;

NSR
Re: SRW.MESSAGE [message #286446 is a reply to message #286431] Fri, 07 December 2007 07:18 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It works fine in my Reports Builder 10g (9.0.4.0.33):

./fa/3540/0/

Can you create a simple example based on Scott's schema? One query, "select * From dept"; add additional formula column which looks the same as the one in my example.

What is the result?
Previous Topic: Multiple pages?
Next Topic: Oracle report 6i to 10g migration
Goto Forum:
  


Current Time: Fri Dec 02 20:31:51 CST 2016

Total time taken to generate the page: 0.09336 seconds