Subject | Bug in In-put parameter of store-procedure |
---|---|
Author | mauleen2001 |
Post date | 2007-06-09T09:48:39Z |
Hi,
I am passing a value FL002,FL003 in store-procedure which is used in
IN clause of sql statement
for example
Delete from container where fileid in (:new_para);
internally it converts into 'FL002,FL003'
but it should be 'FL002','FL003'
so that, i am passing FL002','FL003 from the front end
then it internally converts into 'FL002","FL003'
so how can i evaluate this statement?
Mauleen
I am passing a value FL002,FL003 in store-procedure which is used in
IN clause of sql statement
for example
Delete from container where fileid in (:new_para);
internally it converts into 'FL002,FL003'
but it should be 'FL002','FL003'
so that, i am passing FL002','FL003 from the front end
then it internally converts into 'FL002","FL003'
so how can i evaluate this statement?
Mauleen