There is a new development: Fyracle.

Fyracle is an enterprise quality RDBMS that accepts Oracle style SQL
and implements a large subset of PL/SQL. It is based on the well known
Firebird database.

You can find it at:
http://www.fyracle.org

Or read about it at:
http://software.newsforge.com/software/04/11/29/1917247.shtml?tid=72&tid=132

Fyracle is still a development product (current version is 0.8.2), but
it already supports enough of Oracle's PL/SQL and SQL features to run
the sizeable Oracle application "Compiere" (http://www.compiere.org).

There are installers for Linux and Windows available on the site if
you want to try it for yourself.

Delia wrote:

Too bad you didn't also develop civilized manners to go with it.
Civil manners are what one needs before posting to a usenet group.
They involve the ability to read a group's charter. A desire to
not be viewed as a spammer. And the ability to apologize for a
mistake when so informed.

So we expect to see your apology for spamming this group and
a statement that in the future you will only promote your
products and/or services at c.d.o.marketplace.

Please ignore DA Morgans self rightous criticisms, based on his own
false view of the purpose of this group.  His insults, joined with his
encouragement of others to be 'civilized' are particularly annoying.

The charter of this group encourages discussion of all oracle-related
tools, and I welcome your contribution.   We especially need options now
that Oracle has jacked up prices for front end tools.   I wish someone
would write a tool that could interpret Oracle FMB files and execute
them.  I intend to check this out myself.  Thank You!


Newton Bolton..

DA Morgan wrote:

Show quoteHide quote

Newton Bolton wrote:

When the majority of the group feels as you do expect me to post
advertising for my company here each and every day. Is that what
you'd like?

A it is not 'oracle-related tools' because based on your
definition this would be an appropriate place for Microsoft to
promote Access and SQL Server. For IBM to promote DB2 and
Informix. For Cognos, Brio, Business Objects, BEA, nd 1000
other companies to promote theirs too.

I would suggest you consider the implications of a statement
before making it. Or is that really what you want? These three
usenet groups turned into advertising platforms for everyone
that has anything to sell?

DA Morgan wrote:
   Pointless Threats > /dev/null


You are intentionally misrepreenting my position.   From the charter,
this groups purpose is "to discuss the wide range of tools and
applications available from OR FOR Oracle"


God, you are so insulting!  If you want to be a useful usenet hall
monitor, then be more careful which posts and posters you attack,
and how you attack them.

You attack anyone who suggests any kind of tool that you don't approve
of, and you attack people who are looking for alternatives to Oracle
tools, such as your recent insults against the person looking for a
quick and dirty query tool.

Newt...




Or is that really what you want? These three
Uh, yeh, thats it....

I have read some of this material, and found that Firebird is a free
database that is based on Interbase, which was developed at Dec, taken
over by Borland, and then released as as open source by Borland in 2000.

Firebird continues to be Open Source, free of any license fees even for
commercial use.

Phoenix, seems to be a visual development environment that uses Object
Basic (lose one point)  It is also free.

Fyracle is an interpretor or compiler for Oracle PL/SQL.  (Hence, it IS
an Oracle Tool)  If this works, it could be useful for those of us sick
of Oracle's recent huge price increases for Forms/Reports installations.

The site that distributes these tools is
http://www.janus-software.com  and the only thing I can see that they
sell is consulting, training , setup and configuration.   This makes
their business model very similar to Red-Hat.  You can get everything
free, or, they will make it easier for you by providing an installation
kit ( EUR 49.95 ) and a support contract.

Also posted at   http://tinyurl.com/3qp8g

Show quoteHide quote

Show quote Hide quote A database even with a supporting procedural language IMO is nowhere
close to beig able to replace Oracle Form/Reports.

Exactly how do you envision Fyracle supporting either Client/Server Forms &
Report
or web based Forms & Reports?

ana wrote:
Forms & Report  or web based Forms & Reports?
I don't think it could replace forms/reports, but it could be helpful.
At my company, our investment in Oracle products is in two places.  User
interface, and business logic.

There are many tools that can be used to create user interface.   None
are as good as Oracle Forms, as far as I know, but I have just started
searching.   I have been a devoted fan of Forms since Forms 2.3 (1988? )

Our business logic is entirely written in PL/SQL, so a tool that can
handle and interpret PL/SQL is very attractive.   Oracle wants us to
develop all new features in J-Developer, but we want to investigate
other tools.  Our hope is that Oracle will change their licensing
policy, and allow us to continue with Forms/Reports, but we want to have
a fallback plan in place in case that does not happen.  (See much more
on this at http:/www.csorkldev.com )

If PL/SQL business logic could be moved to Fryacle, that could make
transition to another front end tool easier.  You wouldn't be starting
from scratch with all your code.

Maybe someone would even develop an Oracle Forms emulator.   Then we
could use the Oracle back end and dispense with the expensive and
unnecessary Oracle Application Server.

When Oracle dropped client server, they also dropped free runtime
distribution of the client front end, and made installation much more
complicated for small to mid size environments.    So, it is appropriate
to look for alternatives to that environment.  Oracle is encouraging us
to go to J-Developer, but why should we believe that Oracle won't pull
the rug out from JDev, just as the did for Dev2K?   Anyone betting on
J-Dev after seeing what Oracle did with Dev2k is just asking to be
burned, IMHO.

Oracle insists they are committed to forms/reports long term, but I
simply DO NOT believe them.  They are doing everything they can to
discourage people from developing new applications on that platform.
They even issued a white paper advising customers to do new development
in J-Developer.

We have potentially hundreds of customers for our product, but they are
all small shops, generally less than five users.   Oracle increased
prices in this market by 500% TO 1700% (See
http://www.csorkldev.com/tiki/tiki-index.php?page=PricingOutline)

Ideally, I'd like to identify a set of tools that can work with the
Oracle back end effectively, but don't require Oracle Application
Server, and don't require us to trust Oracle not to burn us again
by turning to JDeveloper.

Best regards,  Newton

nospam@nospam.com says...

You appear to be confused. Fyracle works with the Firebird RDBMS - it is
your back end that you'd be changing, with all the comcomitant changes
that that would mean to any front end. You would have to develop in
something other than Oracle forms.



Paul...

Quick and dirty query tool
Doing Validation before Commit
Need help with OCIDescribeAny()
9.0.1 install on Linux, runInstaller starts, and then stops, no error messages...
What is the fastest way to import XML to Oracle 9i