timezone warnings in 10g
- From: "Oxnard" <oxnardNO_SPAM@xxxxxxxxxxx>
- Date: Thu, 29 Jun 2006 08:08:47 -0500
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>
.
- Prev by Date: Re: update into loop
- Next by Date: Re: Service Name resolution in 10g RAC
- Previous by thread: dbca problem pls help
- Next by thread: bad error ORA-07445 with KSEDMP in trace file
- Index(es):
Relevant Pages
|
