Home » SQL & PL/SQL » 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: 40
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: 10573
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: 18834
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: Mon Apr 21 06:23:46 CDT 2014

Total time taken to generate the page: 0.04173 seconds