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 :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

substr invalid number of parameters [message #573391]

Thu, 27 December 2012 14:45

cplusplus1
Messages: 30
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

Send a private message to this user

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

Thu, 27 December 2012 15:07

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

Senior Member

Then there's something wrong with your ETL tool.

Report message to a moderator

Send a private message to this user

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

Thu, 27 December 2012 15:30

Littlefoot
Messages: 16980
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

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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: Wed May 22 18:47:24 CDT 2013

Total time taken to generate the page: 0.24785 seconds