Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell script.
Here is a clarification:
My pl/sql is:
-----------------------------------------------------------------------
DECLARE
gn_bossid NUMBER(38);
gn_bossaccountid NUMBER(38);
gn_bossaddress NUMBER(38);
gn_voip_directoraddress NUMBER(38);
value1 NUMBER(38);
value2 NUMBER(38);
value3 NUMBER(38);
BEGIN
FOR voip_cparty IN (SELECT V.boss_id, V.bossaccount_id, V.bossaddress
INTO gn_bossid, gn_bossaccountid, gn_bossaddress
FROM Tbossesdata V
WHERE STATE IN ('A')
)
LOOP
BEGIN
value1 := gn_bossid;
value2 := gn_bossaccountid;
value3 := gn_bossaddress;
(1- here i want the shell to read this values
2- Call this same script to perform some other actions according to this values)
END;
END LOOP;
END;
---------------------------------------------------------------------------------------------------
I want the values value1, value2, and value3 to be readen by a shell script inside the loop where the loop is searching and calling the script to run.
what commands should be written in pl/sql and shell to perform this?
I appreciate your kind help.
Thanks!