Hi,
Im calling the SYS.DBMS_RANDOM.STRING package in one of my Stored Procedure and storing this random string value in different tables as primary key.
Inside this PROC, there are multiple occasions(Multiple DML operations) where im calling the same SYS.DBMS_RANDOM.STRING('X',30) to generate a unique value.
Im running this particular PROCEDURE in 40 different session parallely with some different procedural parameters based on business logics.
Will there be a possibility of same number generation occurance???? Need some advise here.
Code used to generate the random number inside the PROC as shown below:-
SYS.DBMS_RANDOM.STRING('X',30)
Regards,
Lazar