Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Getting started into Oracle Forms/Reports..

  • 19-07-2010 4:11pm
    #1
    techguy
    Registered Users, Registered Users 2 Posts: 2,236 ✭✭✭


    Hi There,

    The company I currently work with is using an EPOS system thats based on Oracle forms (I think).

    The way I see it is.. It's developed through an Oracle system.. compiled into Java Bytecode then hosted on a server. Clients connect to the server via web browser which then loads up a Java applet with all the features..

    I've gone to the Oracle site but there's loads of stuff there and I don't really know what i'm looking for..

    I want to develop a working knowledge of it over the next few months. Some of the skills I want to work towards are listed here.. http://www.irishjobs.ie/Jobs/Oracle-Developers-6306531.aspx

    Any ideas on where to start?

    Thanks.


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Does it look like this:

    jhsmig0.jpg

    Or like this:

    020707a-.jpg

    The reason I ask is that I think what you are describing is WebForms (which run via a web browser) as opposed to regular forms (which run as binaries on your client machine).

    That makes a difference when recommending to you where to start.


  • #3
    techguy
    Registered Users, Registered Users 2 Posts: 2,236 ✭✭✭techguy


    It's definitely the first one.. what one is that?

    These are loaded via the web browser but are java applets. I was looking at the Oracle site again and its seems that I need to install the base Oracle DB (like 10g or 11g ?) then an addon for the forms?

    Thanks.


  • #4
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    techguy wrote: »
    It's definitely the first one.. what one is that?

    These are loaded via the web browser but are java applets. I was looking at the Oracle site again and its seems that I need to install the base Oracle DB (like 10g or 11g ?) then an addon for the forms?

    The first one is Webforms because, as you say, it runs from a web browser.

    Ok, now things are more complicated. :)

    These also require an application server along with a database, which to the best of my knowledge you cannot download and install (open to correction on that, I am a DBA, not a developer).

    And did I mention it is a bugger to configure? Once you get your head around app servers (and their lovely DADs among other things), it's not too bad. You will also need one of the Oracle developers suite tools which is free to download (again, open to correction on this).

    As for actual programming of webforms, I've done a bit while troubleshooting "database problems". It's similar enough in concept to Visual Basic, though very clunky. If you have any technical/programming experience at all, you will have no problem.


  • #5
    techguy
    Registered Users, Registered Users 2 Posts: 2,236 ✭✭✭techguy


    Thanks for all your help Tom,

    I'm going to head over to oracle.com and find a forum on there and try and get some help on what exactly I need to download..I have a feeling it's going to be a long ride..

    Cheers.


  • #6
    mwrf
    Registered Users, Registered Users 2 Posts: 523 ✭✭✭mwrf


    Hi Techguy.

    You'll need Oracle developer suite to firstly develop your forms,
    Available here:
    http://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/index.html

    This includes a forms server so you can view your forms running.

    You'll then need an oracle database to compile your forms against,
    Oracle XE will work just fine:
    http://www.oracle.com/technetwork/database/express-edition/overview/index.html


    Once you have a form developed and want to deploy you would need this,
    I wouldn't worry about deployment for the moment though if you're just learning.
    Oracle Application Server, including forms and Reports is available here:
    http://www.oracle.com/technology/software/products/forms/index.html

    Feel free to ask any questions! I work with forms and reports every day.


  • Advertisement
  • #7
    techguy
    Registered Users, Registered Users 2 Posts: 2,236 ✭✭✭techguy


    mwrf wrote: »
    Hi Techguy.

    You'll need Oracle developer suite to firstly develop your forms,
    Available here:
    http://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/index.html

    This includes a forms server so you can view your forms running.

    You'll then need an oracle database to compile your forms against,
    Oracle XE will work just fine:
    http://www.oracle.com/technetwork/database/express-edition/overview/index.html


    Once you have a form developed and want to deploy you would need this,
    I wouldn't worry about deployment for the moment though if you're just learning.
    Oracle Application Server, including forms and Reports is available here:
    http://www.oracle.com/technology/software/products/forms/index.html

    Feel free to ask any questions! I work with forms and reports every day.

    Brilliant stuff.. thanks mwrf!

    I'm going to look into that in the next few days and i'm sure i'll be back with a few questions..

    Cheers!


Advertisement