Try some logic as explained in below blog, javarevisited.blogspot.com/2012/12/xpath-tutorial-example-how-to-select-elements.html#:~:text=XPATH%20to%20select%20an%20element%20based%20on%20attribute%20and%20value&text=%5B%5D%20brackets%20are%20used%20to,%3E%20tag%20with%20%E2%80%9CElectronics%E2%80%9D.&text=here%20%5B%5D%20is%20used%20for,to%20get%20value%20from%20attribute.
Have you liked any of our content and thinking about Thanking us? Then you can thank us / donate us with below links buymeacoffee: www.buymeacoffee.com/beenumlearning PayPal: paypal.me/beenumlearning Below are the links for the courses created by us Learn Integration in Oracle Integration: www.udemy.com/course/learn-integration-in-oracle-integration-oic-from-scratch/?referralCode=A378D1F90CFDA29998D4 Learn B2B for Oracle Integration: www.udemy.com/course/b2b-for-oracle-integration-training-for-beginners/?referralCode=A046790B230F8E7B2648 Learn Insight in Oracle Integration: www.udemy.com/course/insight-in-oracle-integration-oic/?referralCode=6E554C8689FC329746A0
Hi, I need to read the cursor inside the integration to map with another target attributes. Please share any reference doc or video if possible. Thanks
i am getting an error after atp data base added we will get mapper level as name ,seqltype,nill and what type we need to mapp the target filed in write stage file.stage as csv.Please help me on this
Yes, make use of suitable adapters and transform the procedure response into a suitable format whatever your application supports.... Done You may subscribe to this channel if you find this helpful!!!
We have demonstrated in this video the technique to read bulk data with PLSQL, important thing to note here is the SQL query how we write be it in PLSQL or with DB adapter in OIC. We currently share the source code with our TH-cam Gold and above members or you can buy the source code from us for this video alone by writing to us at beenum.apps@gmail.com
@@BEENUMLEARNING Thank you When I am trying to write data to a file, in the mapper section can you pls tell me how I can map each column of my file as the output of the Procedure has only 2 values, Row and column
You have to use Xpath axes while fetching data in case you have generic and repetitive fields. For example //row[attribute name = "something"]/column You may refer document by W3 on xpath axes or you may refer our XSLT playlist www.w3schools.com/xml/xpath_axes.asp
@@nithin0707 Were you able to accomplish this? I am attempting to do the same thing where I need to map all the Select columns into the Target elements to write a file.
Excellent 👌
Your videos are so useful. I have cracked interview by following ur videos 👍
very very nice !!!
Thank for the video, How can we map the Cursor response to FTP or any others. As i dont see any columns in cursor response.
Use xpath predicate and filter the data based on attribute value, you can retrieve unique column values using xpath predicate
@@BEENUMLEARNING would it be possible to share any sample on it please
Try some logic as explained in below blog,
javarevisited.blogspot.com/2012/12/xpath-tutorial-example-how-to-select-elements.html#:~:text=XPATH%20to%20select%20an%20element%20based%20on%20attribute%20and%20value&text=%5B%5D%20brackets%20are%20used%20to,%3E%20tag%20with%20%E2%80%9CElectronics%E2%80%9D.&text=here%20%5B%5D%20is%20used%20for,to%20get%20value%20from%20attribute.
Please keep creating such content.
Thank You Shubham
Have you liked any of our content and thinking about Thanking us? Then you can thank us / donate us with below links
buymeacoffee: www.buymeacoffee.com/beenumlearning
PayPal: paypal.me/beenumlearning
Below are the links for the courses created by us
Learn Integration in Oracle Integration:
www.udemy.com/course/learn-integration-in-oracle-integration-oic-from-scratch/?referralCode=A378D1F90CFDA29998D4
Learn B2B for Oracle Integration:
www.udemy.com/course/b2b-for-oracle-integration-training-for-beginners/?referralCode=A046790B230F8E7B2648
Learn Insight in Oracle Integration:
www.udemy.com/course/insight-in-oracle-integration-oic/?referralCode=6E554C8689FC329746A0
Hi, I need to read the cursor inside the integration to map with another target attributes. Please share any reference doc or video if possible. Thanks
You need to use xpath axes, already covered by us which you can find in XSLT playlist
i am getting an error after atp data base added we will get mapper level as name ,seqltype,nill and what type we need to mapp the target filed in write stage file.stage as csv.Please help me on this
I am getting same error, did you find the solution
Can we write the output of the procedure directly to another application without writing to a file?
Yes, make use of suitable adapters and transform the procedure response into a suitable format whatever your application supports.... Done
You may subscribe to this channel if you find this helpful!!!
can you please provide how to create a package for these can you please share that video
We have demonstrated in this video the technique to read bulk data with PLSQL, important thing to note here is the SQL query how we write be it in PLSQL or with DB adapter in OIC.
We currently share the source code with our TH-cam Gold and above members or you can buy the source code from us for this video alone by writing to us at beenum.apps@gmail.com
getting package compilation error
Error(12,3): PL/SQL: SQL Statement ignored
Error(13,12): PL/SQL: ORA-00933: SQL command not properly ended
Kindly run specification and body for PLSQL separately
Can you please guide me how to write the output of the DB after following these steps into a file
You may use stage action with write file operation or / file / FTP connection to write the content to a file
@@BEENUMLEARNING Thank you
When I am trying to write data to a file, in the mapper section can you pls tell me how I can map each column of my file as the output of the Procedure has only 2 values, Row and column
You have to use Xpath axes while fetching data in case you have generic and repetitive fields. For example //row[attribute name = "something"]/column
You may refer document by W3 on xpath axes or you may refer our XSLT playlist
www.w3schools.com/xml/xpath_axes.asp
@@BEENUMLEARNING Thankyou 😊
@@nithin0707 Were you able to accomplish this? I am attempting to do the same thing where I need to map all the Select columns into the Target elements to write a file.