getting data from DB tables to BF variables

Hi, we need to get data from Oracle tables and use it during BF project.
I can't find any examples how to do it.
I guess we can work with DB from command line but how to set BF variables with values from Oracle tables?

Thank you!

Hi,

One way you could do this is to use the .set or .bset dot commands with a command to get the value between backticks. For example, the syntax would look like the statements below.

.set env <Env_Group_Name> "<Variable_Name>=`Command To Get Value`"

.bset env "<Variable_Name>=`Command To Get Value`"

For the command to get the value, if your program to get the value from Oracle DB only printed that value you could add that in the backticks or perhaps just cat/type a text file that has the value.

bju