Timestamp size being included in parameters in procedures.sql

[GoogleCodeExporter]

What steps will reproduce the problem?
1.
CREATE TABLE  "Location" 
   (    "ID" RAW(16) NOT NULL ENABLE, 
    "NAME" NVARCHAR2(2000) NOT NULL ENABLE, 
    "DESCRIPTION" NVARCHAR2(2000), 
    "CENTERLATITUDE" FLOAT(126), 
    "CENTERLONGITUDE" FLOAT(126), 
    "CREATED" TIMESTAMP NOT NULL ENABLE, 
    "LASTMODIFIED" TIMESTAMP NOT NULL ENABLE
   )
/

2. Create project for Oracle

What is the expected output? What do you see instead?
The stored procedures generated includes the timestamp size (which 
defaults to (6)) in the parameters.  Here is a sample of the parameters 
that get created:

CREATE OR REPLACE PROCEDURE ProjectDAL.Location_Insert
    (
        p_Id IN RAW  ,  
        p_Name IN NVARCHAR2  ,  
        p_Description IN NVARCHAR2  ,
        p_Centerlatitude IN FLOAT  ,
        p_Centerlongitude IN FLOAT  ,
        p_Created IN TIMESTAMP(6)  ,    
        p_Lastmodified IN TIMESTAMP(6)
    )

What version of .netTiers and CodeSmith are you using?
.netTiers 2.3, CodeSmith 5.2

Please provide any additional information below.
When running procedures.sql with the problem above you get the error:

PLS-00103: Encountered the symbol "(" when expecting one of the 
following: := . ) , @ % with default character The symbol ":=" was 
substituted for "(" to continue

As with the rest of the data types timestamp should not include a size for 
parameters of a stored proc.

Original issue reported on code.google.com by wordry...@gmail.com on 16 Apr 2010 at 3:30

[GoogleCodeExporter]

Please note that this should be on the Oracle Platform.

Original comment by wordry...@gmail.com on 16 Apr 2010 at 3:35

[GoogleCodeExporter]

Hello,

Can you please verify that this is still an issue with revision 838.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 2 Jun 2010 at 4:14

• Changed state: AwaitingInfo
• Added labels: Platform-Oracle
• Removed labels: Platform-SQL