1 Reply Latest reply on Apr 30, 2004 9:08 AM by Ricardo Arguello

    Problem when trying to extract values from XMLType from orac

    mtechsrinivas Newbie

      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