0

I want to write a sript in BODS which will call an Oracle SP, which upon passing 2 parameters will return a sys_refcursor containing 3-4 columns. How to write such a script so that that returned value can be stored in a variable and displayed.

astentx
  • 6,393
  • 2
  • 16
  • 25
TBose
  • 115
  • 2
  • 10
  • BODS is for data transformation. How do you want to display it? – astentx Jul 15 '21 at 10:35
  • I want to call an Stored procedure in SQL script from Oracle. The script deletes data from table. The created job will then be scheduled. But I don't know what script to write – TBose Jul 15 '21 at 15:13

0 Answers0