Skip to Main Content

SQL Developer

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!

Code insight does not work for conditional compilation

jbosmanJul 3 2017 — edited Jul 3 2017

This code is not parsed correctly by sql developer 4.2. It gives the message:

Syntax error. Partially recognized rules (railroad diagrams): ELSEIF plus := $ELSIF ...

on line 4 (gt_fermoccurences ...)

It seems it expects only 1 line of code after the $if

CREATE PROCEDURE TST AS

    $if $$ferm_dbg $then

        TYPE t_fermoccurences IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(60);

        gt_fermoccurences t_fermoccurences;

    $end

BEGIN

    NULL;

END;

Comments

Thanos A

Hi there,

Have you confirm that the NumDecimalPlaces of the stat account is not zero but it is more than 1? Only if you have a NumDecimalPlaces value, HFM will not round the number during the input.

Regards,

Thanos

One Truth about...: ...Apps 13, London

Dakku

Would this be in the metadata?

Thanos A

Hi again,

Yes, you should confirm that the stat account that you have created has as a NumDecimalPlaces attribute the value 1. Based on that you will be able to input data with one decimal.

Regards,

Thanos

One Truth about...: ...Apps 13, London

AmarnathK

Yes. You can have a look at the Account properties. Same place where you would see isCalculated, isConsolidated properties

Regards

Amarnath

http://amarnath-essbase-blog.blogspot.com

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 31 2017
Added on Jul 3 2017
1 comment
883 views