aspose file tools*
The moose likes JDBC and the fly likes oracle to cloudscape Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle to cloudscape" Watch "oracle to cloudscape" New topic
Author

oracle to cloudscape

satish gutta
Greenhorn

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

Joined: Jan 10, 2002
Posts: 60057
    
  65

"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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29255
    
140

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
satish gutta
Greenhorn

Joined: Oct 13, 2006
Posts: 4
Thank you!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle to cloudscape
 
Similar Threads
Error while connecting Oracle with Java
Creating Cloudscape database and data sources in Web Sphere
Pinging a Remote DataBase
sqlplus problem in antinstaller
sqlplus