Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
Process Mapping > Categories > The Forums > Using Oracle built in functions in Query BO
 
 


Reply
  Author   Comment  
JCKiran

Senior Member
Registered:
Posts: 58
Posted Reply with quote  #1 
Hi,

I am trying to use Oracle built in function like To_Date(date,'dd/mm/yyyy') in query BO. This throws an error message at run time.
Anyone got any idea how can we use the Oracle builtin functions from BO?
__________________
Kiran
0
BMellert

Guru
Registered:
Posts: 688
Posted Reply with quote  #2 
Any idea what the error message is?  You should need to give the column as alias (e.g. to_date(date,'dd/mm/yyyy') datecol) as MBPM doesn't know how to "name" that function without an alias, but I'd think it would work otherwise.  It does in SQL anyway.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!