Hi. I start to create a data source based on view and I get the following errors: ORA-06512 at FORMSPIDER.BDF_DATASOURCEDEFATRIB_API line 13 ORA-06512 at FORMSPIDER.BDF_DATASOURCEDEF_TYPEAPI line 387 ORA-06512 at FORMSPIDER._IDE_DATASOURCECOMMIT_II line 76 ORA-06512 at FORMSPIDER.API_APPLICATION line 45 ORA-06512 at FORMSPIDER.BDF_IDE_INTERFACE_PKG line 1517

asked 15 Aug '12, 00:19

DPushkashu's gravatar image

DPushkashu
16219
accept rate: 25%


Hi DPushkashu,

Please check your column datatypes, Formspider only supports VARCHAR,DATE,NUMBER,CLOB and BLOB columns.

Regards

link

answered 15 Aug '12, 00:52

Samet%20Basaran's gravatar image

Samet Basaran
1372
accept rate: 24%

Hi Samet. But, I need to use TIMESTAPM(6) as data type for table column. What can I do in this case? I am understand that I can modify it as DATE, but I need to have a time too. Can you advice me anything? Thanks.

link

answered 15 Aug '12, 01:55

DPushkashu's gravatar image

DPushkashu
16219
accept rate: 25%

Hi DPushkashu,

You may convert it to VARCHAR2 with time values:

SELECT TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS') FROM DUAL

Also you may convert it to DATE, similar as VARCHAR2:

SELECT TO_DATE (TO_CHAR (SYSTIMESTAMP, 'YYYY-MON-DD HH24:MI:SS'), 'YYYY-MON-DD HH24:MI:SS' ) FROM DUAL

link

answered 15 Aug '12, 02:46

Samet%20Basaran's gravatar image

Samet Basaran
1372
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×63
×43

Asked: 15 Aug '12, 00:19

Seen: 1,577 times

Last updated: 15 Aug '12, 02:46


© Copyright Gerger 2017