PB11 and Oracle 10 storeproc

[BBO007]

Hi all,
I have an issue I would like to share with you.

I would like to have a DW based on a Oracle store procedure.
I would like that the store proc to have a IN parameter of type VARCHAR2. And the contents of this parameter will be a list of string values, like
param1 = ('Val1','Val2','Val3')
The contents of the variable is built in my PB code.

When I am testing the SQL query directly in Oracle, the follow query is not working and I have no result:
SELECT * FROM TABLE_1
WHERE FIELD_1 in aram1 ;

On the other hand, the following query here is working ok:
SELECT * FROM TABLE_1
WHERE FIELD_1 in ('Val1','Val2','Val3') ;

Is this means something to you ?
Do I have to change the contents of the param1 variable ?

I have already done a storeproc with string parameters or dates, but with one one value at a time, and this is ok.
Now, I would like to go further with the parameter.

Thank you in advance for your help.
BBO007

 

[miguelleeuwe]

check out the next link:

PowerBuilder: Article
Using Oracle Stored Procedures in Your DataWindows By Bruce Armstrong

http://brucearmstrong.sys-con.com/node/42529/mobile

I haven't had the oportunity to try it myself, but I think it'll solve your problems.


regards,
Miguel L.