Hi,
could you show me in detail to correct my error.
My trigger look like:
Declare
CheckOK Boolean := False;
v_connect_string Varchar2(500) := ' ';
Username Varchar2(50) := ' ';
Pwd Varchar2(100) := ' ';
v_url Varchar2(500) := ' ';
Begin
UTIL_P.Check_input_Conditions (CheckOK => CheckOK);
if CheckOK then
username := 'brokersys'; --get_application_property(Username);
pwd := 'sys'; --get_application_Property(password);
v_connect_string := 'ibs'; --get_application_property(Connect_String);
v_url := '/reports/rwservlet?'||--'http://abc:8888/reports/rwservlet?server=rep_ORAserver'||
--'report=print_bao_cao_kqgd.rdf&desformat=htmlcss'| |
'&userid='||LTRIM(RTRIM(username)) || '/' || LTRIM(RTRIM(pwd))||'@'||v_connect_string||
'&ip_From_Branch='||:PRINT_BAO_CAO_KQGD_B.FROM_BRA NCH ||
'&ip_To_Branch=' ||:PRINT_BAO_CAO_KQGD_B.TO_BRANCH ||
'&ip_From_Date=' ||TO_CHAR(:PRINT_BAO_CAO_KQGD_B.FROM_DATE,'DD/MM/YYYY') ||
'&ip_To_Date=' ||TO_CHAR(:PRINT_BAO_CAO_KQGD_B.TO_DATE,'DD/MM/YYYY') ||
'&ip_ho_name=' ||LTRIM(RTRIM
'¶mform=no';
web.show_document(v_url, '_blank');
else
Display_Err_P.Display_error('ERR','Check Again!');
End if;
Exception
When Others then
Message(SQLERRM);Message(SQLERRM);
End ;
Thank in advance???