Home » Other » Client Tools » substr invalid number of parameters (11)
substr invalid number of parameters [message #573391] Thu, 27 December 2012 14:45 Go to next message
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.
Re: substr invalid number of parameters [message #573392 is a reply to message #573391] Thu, 27 December 2012 15:07 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then there's something wrong with your ETL tool.
Re: substr invalid number of parameters [message #573393 is a reply to message #573392] Thu, 27 December 2012 15:30 Go to previous message
Littlefoot
Messages: 21806
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).
Previous Topic: migration from windows-mssql to linux-oracle.
Next Topic: How to disable shortcut or change key mapping?
Goto Forum:
  


Current Time: Thu Mar 28 12:51:29 CDT 2024