I think that might be it Jim. If my_table has more than one field, don't you need to list which field to store the value of i into? If it is only one field, what about trying to assign the wrong type?
(Of course, wiwya doesn't have email notification turned on, so they'll probably never read this...) Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
Maybe someone clever will figure out the problem. However there would be much less guesswork if you would include in your post the error that you're getting.
Karluk, is DBMS_RANDOM a "standard" package with Oracle? I guess what I mean is, is there a chance that that package wasn't installed? I am asking Karluk, cause he is more experienced at this than I am. Anyone else know, please jump in. How do you find out if a package has been installed/compiled? Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
Sorry, Terry, but that's the risk you take directing a post a specific person. I didn't know which scripts to run to create dbms_random, but fortunately this issue has been addressed in thread186-69028. Please check it out for details. Many thanks, Stevecal.
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.