Re: [sqr-users] Problem with SQR string concatenation ? Please help!

[Antonio Guiza <aguiza@pcc.edu>]

Try something like this:

select '('||''''||'A6'||''''||','||''''||'A7'||''''||')' from dual;

Output:
---------
'A6','A7'

At 04:29 PM 1/29/03 -0800, you wrote:
>I formed a string concatenating few of the command
>line arguments. I checked for the wellformedness of
>the resultant string, it was exactly what I wanted..
>
>I went into a procedure, there I concatenated the
>string with parenthesis; it looked good. But, when I
>try using this string inside sql select statement
>(begin-select...end-select), it won't be
>recognized..don't know why..
>
>Code fragments:
> >>>string<<<
>$agycodes = 'A6'||','||'A7'||','||'M4' =>
>'A6','A7','M4'
> >>>inside procedure<<<
>let $agycodes = '('||$agycodes||')'
>#debug show $agycodes.....would give me
>('A6','A7','M4') which is what I want.
>
> >>>inside select statement<<<
>begin-select
>agy_wc &agywc
>agt_wc &agtwc
>agt_seq &agtseq
>.....
>.....
>from t_agents .....
>where
>agy_wc = $agycodes and .....
>.....
>end-select
>
>Works when I hard-code ('A6','A7','M4') in place of
>$agycodes, but won't work otherwise. It won't give me
>any error or exception, however the sqr will terminate
>immediately, which makes it even more difficult to
>debug..Any idea what's happening ? Is it something to
>do with parens, commas ? Would really appreciate any
>help..
>
>Thanks in advance..
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


---------------------------------------------------------------------------------------------------
Antonio G. Guiza                                        mailto:aguiza@pcc.edu
Programmer/Analyst                                                (503) 
977-4395
Portland Community College  SY CC-224             fax (503) 977-4987
ITS Systems Development                                 http://www.pcc.edu
---------------------------------------------------------------------------------------------------

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users