Hello experts,
I am having problem when i am trying to execute the following query from BMP bean.
select mca.application.extract('//cand-name/text()').getStringVal(), mca.application.extract('//father-name/text()').getStringVal(), mca.application.extract('//marks-percentage/text()').getStringVal(), mca.application.extract('//dob/text()').getStringVal(),
mca.application.extract('//amount/text()').getStringVal()
from appform mca where mca.appform_id in ('bd1006','bd1005','bd1004','bd1002
','bd1001','bd1000')
In the above query i am extracting five fields from the XMLType column.
This query is working fine from sql promt but if i try to execute this query from bmp the the error i am getting is
0ra-04013(insufficient shared memory)
currently my shared_pool_size in oracle 9i is 45 MB.
currently my java_pool_size is 35MB
But if i change the query into this
select mca.application.extract('//cand-name/text()').getStringVal(), mca.application.extract('//father-name/text()').getStringVal(), mca.application.extract('//marks-percentage/text()').getStringVal(), mca.application.extract('//dob/text()').getStringVal() from appform mca where mca.appform_id in ('','bd1006','bd1005','bd1004','bd1002
','bd1001','bd1000')
In the above query i am extracting only 4 fields.
Then iam getting the out put.
Please can any one help me to solve this problem.
Thanking you,
Srinivas
