PL/SQL procedure successfully completed.
it works !
I've runned this commands:
@utlraw.sql
@prvtrawb.plb
@dbmsoctk.sql
@prvtoctk.plb
@dbmsrand.sql
thank's for yor help
the error I m getting is:
DBMS_RANDOM.INITIALIZE undeclared identifier,
the same for DBMS_RANDOM.RANDOM and DBMS_RANDOM.TERMINATE
thank's for your help
(I turn on my e-mail notification)
could someone tell me why this code does not work?
DECLARE
i BINARY_INTEGER;
BEGIN
dbms_random.initialize(19254);
i := dbms_random.random;
INSERT INTO my_table VALUES(i);
dbms_random.terminate;
END;
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.