nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BIP Editor is not giving relevant error like TOAD and SQL Developer

Srini Devara

Description

BIP Editor is not giving relevant error like TOAD and SQL Developer

Use Case and Business Need

BIP data set editor is not giving relevant errors always use to give same error for different type mistakes.its very hard to figure out exact issue.

if it shows relevant error like TOAD,SQL developers it will helps developer to correct error very easily and repidly

Original Idea Number: ac6a63473a

Find more posts tagged with

Submitted

BI Publisher

Status: Submitted

Comments

Reese Pratt

Agreed. Sine we have to the queries in the web, it would be nice if there was a simple SQL editor incorporated into BIP.

Chinna Reddeppa-26516

Agree.

Geraud Andreux

Hello,

definitely! If it could at least indicate the line number of the issue, that would help.

Personally I've found a partial workaround by using a local "Oracle SQL Developer" installation (free from oracle), that I use as a SQL editor.

It cannot connect to the database, but at least it will underline some of the most common errors, like the missing commas, mismatching brackets, misspelled keywords, etc.

Also, the SQL auto-format feature is very useful,

When I paste the code in BIP I'm much less likely to get those errors,

hope this helps,

cheers,

Géraud

AshishERPCloud

Yes you may choose the language as SQL and try to paste the code in Textpad and Notepad++ and you should be good.

Reese Pratt

Having to copy and paste back and forth completely defeats the purpose of having a cloud based application though.

AshishERPCloud

hmmm.

Cloud also has its own set of limitation.

I mean it is a surprise that organizations wont implement HCM Cloud only because this feature is not there.

Alternatively, you may use the SQL Builder option too.

Note: My personal opinion.

Andreas Ehrenstein

Actually the error messages confuse, and are a waste of time. Sometimes it sounds, it is better to create on SR per SELECT term you need to write and let Oracle use the SQL Developer access in bahalf of you
Regards