On 18-7-2014 14:00, 'checkmail' [email protected] [firebird-support] wrote: > If I use the following code to extract a part of a string, it works fine: > > s_datum = substring(:dat from 13 for 4); > s_datum = char(4) > > Now I would give the same a stored procedure, the first input parameter > is XXX varchar(30), it returns me the integer-value and the status > (passed or not) > > select int_out, status from P_u_cn_to_int(substring(:dat from 13 for 4)) > into :i_z1, i_status1; > > The second thing – it does not work – why? If I set the input-parameter > to ‘1234’, it works, but the substring?
"It does not work" is a bit vague. What is the value of dat, and what is the result of the substring? Does it match the expectations of the stored procedure? Mark -- Mark Rotteveel ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
