Skip to Main Content

APEX

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!

Timeline Plugin - COM.GPMFACTORY.RESOURCE_DIAGRAM

Jeff WellsMar 8 2024 — edited Mar 8 2024

Is there anyone out there who is using this plugin for rendering timelines? I keep getting the dreaded ORA-06502: PL/SQL: numeric or value error: character string buffer too small error thrown when I attempt to render the page.

Here is the table DDL that I am writing the SQL Query against.

CREATE TABLE "TIMELINE_TBL"
( "TIMELINE_ID" NUMBER(*,0) NOT NULL ENABLE,
"RESOURCE_NAME" VARCHAR2(2056),
"START_DATE" DATE NOT NULL ENABLE,
"TASK_NAME" VARCHAR2(2056) NOT NULL ENABLE,
"END_DATE" DATE NOT NULL ENABLE,
"GROUP_NAME" VARCHAR2(2056) NOT NULL ENABLE,
"CREATED" DATE,
"CREATED_BY" VARCHAR2(255),
"UPDATED" DATE,
"UPDATED_BY" VARCHAR2(255),
CONSTRAINT "TIMELINE_TBL_TIMELINE_ID_PK" PRIMARY KEY ("TIMELINE_ID")
USING INDEX ENABLE
) ;

Here is the Source SQL Query code:

select
timeline_id id,
group_name,
task_name,
start_date,
resource_name,
end_date
from
timeline_tbl

Here are the region Attribute settings:

I see this when select the list for Start Date column

Comments
Post Details
Added on Mar 8 2024
2 comments
244 views