Passing Sql IN Clause in Forms 6i

[taqmeena]

HI every body.
i am using Oracle Forms 6i
I want to pass some values to the IN clause of a sql statement in the form builder.
as

MY_CUR CURSOR is Select * from My_Table
where My_Table_ID in ( 10,12,15 );

above statement Work Sucessfully!

problem Occure when the IN Clause Values ( 10,12,15 ) Can be changed at Runtime by the User. as user's requirements may be.

user insert Desired values in a Multiple Records DataBlock.
i stored them into a Global Variable Global_var. as user values are in Global_var = '14,15,25,29'

now i pass this global variable to the Runtime Cursor as


MY_CUR CURSOR is Select * from My_Table
where My_Table_ID in ( :Global.var );

but this statement raise an Exception

Please guide me in this problem if any one got that idea.

"Simply i want to know who can we pass values to IN Clause at runtime in a form."

 

[lewisp]

Try enclosing your sql in quotes.

'Select * from My_Table
where My_Table_ID in (' || :Global.var || ')';

 

[taqmeena]

sorry it did'nt worked is there any other solution