Search results for query: *

I should say that it's not exactly what I have in my exampl - mine included the parens - however I also tried your suggestion

Exactly what I originaly had. thanks anyway.

varchar2

Sem, Don't know if you saw my earlier post but again I'm pretty sure I quoted those strings correctly. Give an example if you see that I am doing this incorrectly.

Sem, In the average package I would agree however in my scenario they would need extensive knowledge of the package to make sure it didn't bomb. It is only for a ref cursor which controls the flow of the package. ie. open cursor_name for input_select_string; LOOP Exit when... Fetch...

sem, I'm pretty confident I quoted them correctly, this is how I set up a string in testing which included the parens: in_string = '(''id1'',''id2'',''id3'')' surrounding the IDs are two single quotes so that they would be recogized as single quotes. FYI - this is just a basic example - not...

I have found a solution (may not be the best but it seems to work). In this particular usage there are actually 3 different parameters that need to allow for IN statements (not just one in my example above). I am now forming the Select statement on the client side and passing that in as a...

I'm attempting something similar - need to pass in a parameter(s) to be used in an IN statement in the where clause (comming from .NET). I have tried strings into a normal cursor i.e.: '''id1'',''id2'',''id3''' to no availe. I attemped the solution given by lewisp but recieve error 904, Here...