We have a Oracle database which is centralized and is the sandbox for dev. A new task has been assigned to establish a local cloudscape V5.1 database embedded in RAD 6.0 using the existing sql script of oracle... Upon doing lot of research I found that cloudscape doesnt support stored procs...and uses sqlj which is completely different from sqlplus of oracle. The scripts I have contain 3-4 stored procedures and they have lotz of dependencies.
I have all the script files of sqlplus...and need to migrate from centralized oracle to local cloudscape..is it possible?
any help regarding this will be appreciated hoping to hear soon.
There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
There isn't any easy way to migrate stored procedures from Oracle to Cloudscape. One of the key features of stored procedures is that they are database specific. I recommend asking for permission to point to the centralized Oracle database from your RAD workspace.
0
