Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78

    Unanswered: Creating Package on the fly (novice)

    I don't know how many months I can still say I'm a novice, but I am.

    I typically use TOAD to edit a package body. It makes it easy but shelters me from learning a bit.

    I haven't been able to find a programatic oracle GUI front end, so I typically use Access/forms/VBA to call batch files that run the internal package.
    I have some changes to the package that need to be done on a individual run basis. What I would like to do is have an Access app "feed" the package to oracle and then kick off the package like I typically do.

    I just don't know if there is a way to get the package into oracle.

    Anyone have any suggestions?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    The Oracle GUI is: SQL Developer.
    Packages should be static and NOT be "changed" on a per-run basis -- Try using PARAMETERS.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •