timezone warnings in 10g

From: Oxnard <oxnardNO_SPAM_at_comcast.net>
Date: Thu, 29 Jun 2006 08:08:47 -0500
Message-ID: <u5WdnfEhFfR-TT7ZnZ2dnUVZ_rqdnZ2d@comcast.com>

I am not understanding why I am getting the warning message. I have tried changing the data type in jtime from 'timestamp with time zone' to timestamp. Also I have tried using the current_timestamp and localtimestamp. What am I missing here??

Thanks

SQL> @timezone
SQL> set serveroutput on
SQL> set echo on
SQL> set feedback on
SQL>
SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Solaris: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

5 rows selected.

SQL>
SQL> alter session set PLSQL_WARNINGS = 'enable:all';

Session altered.

SQL>
SQL> drop table jtime;

Table dropped.

SQL>
SQL> create table jtime(jtime timestamp with time zone);

Table created.

SQL>
SQL> create or replace procedure jtimePro as   2 begin
  3 insert into jtime values(systimestamp);   4 end jtimePro;
  5 /

SP2-0804: Procedure created with compilation warnings

SQL>
SQL> show errors
Errors for PROCEDURE JTIMEPRO:

LINE/COL ERROR

-------- -----------------------------------------------------------------
3/28     PLW-07202: bind type would result in conversion away from column
         type

SQL>

SQL>
SQL> Received on Thu Jun 29 2006 - 08:08:47 CDT