File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes oracle to cloudscape Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "oracle to cloudscape" Watch "oracle to cloudscape" New topic

oracle to cloudscape

satish gutta

Joined: Oct 13, 2006
Posts: 4
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 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

Joined: Jan 10, 2002
Posts: 63540


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.

JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
satish gutta

Joined: Oct 13, 2006
Posts: 4
Thank you!
I agree. Here's the link:
subject: oracle to cloudscape
jQuery in Action, 3rd edition