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 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.