Compilation Error [message #37713] |
Fri, 22 February 2002 20:19 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
I build a procedure like this :
create or replace procedure seltrans as
declare
stmt varchar(500);
sel varchar(100);
frm varchar(100);
cond varchar(300);
begin
sl:='select a.msisdn,eop,jumtag,tgllunas,jumbyr,tglbayar,region';
fr:=' from regional,cdra.activation a,tagihan01 t, pembayaran01 p';
cond:=' where kode_reg=''01'' and a.msisdn=t.msisdn and a.msisdn=p.msisdn'
||' and to_char(tglbayar,''YYYYMM'')=eop';
stmt:=sel || frm || cond ;
dbms_output.put_line(stmt);
execute immediate stmt;
end;
/
can you check where's the error
cause it said that :
the procedure is created with compilation error
thanks
|
|
|
Re: Compilation Error [message #37714 is a reply to message #37713] |
Fri, 22 February 2002 20:58 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
changed the code into this :
create or replace procedure seltrans as
begin
select a.msisdn,eop,jumtag,tgllunas,jumbyr,tglbayar,
region from regional,cdra.activation a,tagihan01 t, pembayaran01 p
where kode_reg='01' and rtrim(a.msisdn)=rtrim(t.msisdn)
and rtrim(a.msisdn)=rtrim(p.msisdn)
and to_char(tglbayar,'YYYYMM')=eop
end seltrans;
/
and still the compilation error appear...
|
|
|
|
Re: Compilation Error [message #37725 is a reply to message #37713] |
Mon, 25 February 2002 07:28 |
Tamim
Messages: 23 Registered: October 2001
|
Junior Member |
|
|
Use
SHOW ERR
and see what the errors are. If you need paste the errors in the message board and then someone could help you.
Regards
Tamim
|
|
|