1

I have a requirement like inserting a large data from visual prolog end to the oracle database and also most importantly all the data needs to be injected through a single stored procedure call. I have tried them passing the data as string values, but there is a constraint in visual prolog like the length the string variable cannot exceed '250' characters. So passing them as strings is not viable for my requirement. so I tried passing the data in the form of prolog list using term_str(). But unfortunately the list/array item is not handled at the oracle end. My DBA has suggested me to pass the large data in the form of an array objects. Do anybody have an idea how to convert the array data into an array object in visual prolog. or any other recommendations for inserting the large data into database through a single stored procedure call??

Cling
  • 489
  • 1
  • 6
  • 15

1 Answers1

2

Not sure about Visual Prolog, but for SWI there is a nice chapter in the manual on the ODBC

Sebastian
  • 6,293
  • 6
  • 34
  • 47
Alexander Serebrenik
  • 3,567
  • 2
  • 16
  • 32