| 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
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
