OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » SRW.MESSAGE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SRW.MESSAGE [message #286388]

Fri, 07 December 2007 04:31

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

Report message to a moderator

Re: SRW.MESSAGE [message #286389 is a reply to message #286388]

Fri, 07 December 2007 04:32

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Outside Reports? You can't.

MHE

Report message to a moderator

Re: SRW.MESSAGE [message #286391 is a reply to message #286388]

Fri, 07 December 2007 04:35

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

Report message to a moderator

Re: SRW.MESSAGE [message #286392 is a reply to message #286388]

Fri, 07 December 2007 04:39

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

Report message to a moderator

Re: SRW.MESSAGE [message #286394 is a reply to message #286392]

Fri, 07 December 2007 04:42

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What error? Besides, what reports version are you working with?

MHE

Report message to a moderator

Re: SRW.MESSAGE [message #286397 is a reply to message #286392]

Fri, 07 December 2007 04:50

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: SRW.MESSAGE [message #286417 is a reply to message #286394]

Fri, 07 December 2007 05:37

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

Report message to a moderator

Re: SRW.MESSAGE [message #286431 is a reply to message #286394]

Fri, 07 December 2007 06:15

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

Report message to a moderator

Re: SRW.MESSAGE [message #286446 is a reply to message #286431]

Fri, 07 December 2007 07:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It works fine in my Reports Builder 10g (9.0.4.0.33):

/forum/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?

Attachment: srw_message.PNG
(Size: 22.78KB, Downloaded 23727 times)

Report message to a moderator

Previous Topic:	Multiple pages?
Next Topic:	Oracle report 6i to 10g migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 14:06:24 CDT 2025