Page 1 of 1
Error whil executing userdefined function in DS
Posted: Thu Oct 25, 2007 3:39 am
by baglasumit21
I am trying to execute a user defind function in DS through query as given below. When I click on view data I am able to see it but when I execute tha job it is aborting by giving message as invalid character.
My query is
Select User_defN_Func(1) from Dual;
Please let me know the solution to this
Re: Error whil executing userdefined function in DS
Posted: Thu Oct 25, 2007 3:56 am
by ogmios
Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
Re: Error whil executing userdefined function in DS
Posted: Thu Oct 25, 2007 4:22 am
by baglasumit21
ogmios wrote:Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
It worked. It was my mistake. I gave a ; at the end of the query. Thats why it was giving an error as invalid character. Now its working fine.
Thnx...
Re: Error whil executing userdefined function in DS
Posted: Thu Oct 25, 2007 4:22 am
by baglasumit21
ogmios wrote:Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
It worked. It was my mistake. I gave a ; at the end of the query. Thats why it was giving an error as invalid character. Now its working fine.
Thnx...
Posted: Thu Oct 25, 2007 7:08 am
by chulett
Exactly - two things will typically generate that 'invalid character' error in Oracle: a semi-colon or untranslated job parameters.