Apr 2, 2001 #1 acarrillo Programmer Joined Apr 2, 2001 Messages 2 Location US Hello. I have installed Oracle 8i V8.1.6., but don't have the DBMS_random . Where do i import it? Help me Please!
Hello. I have installed Oracle 8i V8.1.6., but don't have the DBMS_random . Where do i import it? Help me Please!
Apr 2, 2001 #2 stevecal Technical User Joined May 10, 2000 Messages 78 Location DK It's certainly available in Oracle 8, in the dbmsrand.sql script. It may not have been installed. As SYS you should run the following scripts exactly in this order: dbmsoctk.sql; prvtoctk.sql; dbmsrand.sql If you haven't got these scripts anywhere it's almost certain your version of Oracle won't support DBMS_RAND Upvote 0 Downvote
It's certainly available in Oracle 8, in the dbmsrand.sql script. It may not have been installed. As SYS you should run the following scripts exactly in this order: dbmsoctk.sql; prvtoctk.sql; dbmsrand.sql If you haven't got these scripts anywhere it's almost certain your version of Oracle won't support DBMS_RAND