OraFAQ Forum: Client Tools » substr invalid number of parameters

Home » SQL & PL/SQL » Client Tools » substr invalid number of parameters (11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

substr invalid number of parameters [message #573391]

Thu, 27 December 2012 14:45

cplusplus1
Messages: 58
Registered: October 2012
Location: usa

Member

I am using the following substr and it works fine on Toad but when i am trying to use within an ETL tool, there getting the error:

substr(PBBDT,length(PBBDT)-1)

Calling <substr> with <2> parameters, but <3> are expected.

Thanks for the helpful info.

Report message to a moderator

Re: substr invalid number of parameters [message #573392 is a reply to message #573391]

Thu, 27 December 2012 15:07

cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then there's something wrong with your ETL tool.

Report message to a moderator

Re: substr invalid number of parameters [message #573393 is a reply to message #573392]

Thu, 27 December 2012 15:30

Littlefoot
Messages: 21647
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why wouldn't you, then, supply the 3rd parameter? Its value is 2, always (in your case, I mean).

Report message to a moderator

Previous Topic:	migration from windows-mssql to linux-oracle.
Next Topic:	How to disable shortcut or change key mapping?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 17 16:53:44 CST 2021