Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pillar

843854Jun 20 2003 — edited Jun 20 2003
Hello.
I am importing data from pillar file to Oracle.But experienced a problem when tha data type ie varchar in pillar is of bigger size.
By pillar data type is varchar(65500) I changed this size to varchar(4000) programtically (ie when I create the tables in Oracle data base programatically),as it complined abt the size.But during the data import the data are not imported for the particulat column Note:only this column.Its give me null value.Later I founfd that its not reading data from the particular column from the pillar file.
Does anyone has an annswer pls let me know.Or if u find some alternate solution to import data from pillar to oracle you are welcomed
Thnaks in advance

Shaiju

Comments

fac586

Looks like P22_DATE_RANGE does not have one of the expected values in session state when the report is rendered.
Is P22_DATE_RANGE included in the region Page Items to Submit source property? Does the LOV actually return the values Daily or Weekly?
Check using the session viewer in the developer toolbar.
I would also suggest that rather than doing the conversion in the query, the Dates column should be returned in DATE type and formatted using the Format Mask property to get proper sort semantics and filter options

Stax

Hi, Sunny-Oracle

select project_name, Dates, sum(records_number) as 
from (
select project_name, 
 case 
  when :P22_DATE_RANGE = 'Daily' then
   to_char(date_sys, 'DD-Mon-YYYY') 
  when :P22_DATE_RANGE = 'Weekly' then
   to_char(TRUNC(date_sys, 'IW'), 'DD-Mon-YYYY')
  else
   'ERROR: '||:P22_DATE_RANGE||'.'
 end as Dates,  
 RECORDS_NUMBER
from BATCH
WHERE date_sys BETWEEN TO_DATE(:P22_START_DATE) AND TO_DATE(:P22_END_DATE)
) my_records
group by project_name, Dates
;
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2003
Added on Jun 20 2003
#java-database-connectivity-jdbc
1 comment
84 views