hi,
1. when i inserted data in transaction table i used trunc(sysdate). but
while retrieving data it shows
date plus time like "1999-10-13 00:00:00.0".
my query is select * from transaction . i cant specify my date format.
is there any way to resolve this problem . iam sending the package body
and my java code. i want date to be displayed as "mm/dd/yyyy".
---
create or replace package body pkg_ebanc as
function fun_transaction(accountno in varchar2) return c_gmm03trnsaction
is
c_trans c_gmm03trnsaction;
begin
open c_trans for
select *
from GMM03TRNSACTION
where C001CUSTACCTNO like ltrim(rtrim(accountno));
return c_trans;
end fun_transaction;
end pkg_ebanc;
-----
2. when i use an jpeg file for background
<body background=./images/pic.jpg>
it says
"servlet not found : images"
how to solve this problem . i want all my images (jpeg,bmp,.. ) to be
kept in images dir.
-----------
stmtRequest.java
