• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle to cloudscape

 
satish gutta
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

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.

Thank you all for reading my query.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64720
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"sat_abi",

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.

Thanks!
bear
JavaRanch Sheriff
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34229
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Satish,
Thanks for updating your display name.

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.
 
satish gutta
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic