Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Oradam

    Oracle Repository 6i

    Hi All, I have been searching for a way to do revision control within my stored Oracle code (procedures, functions, packages, etc) and came across Oracle's Repository 6i. I installed the application in its own database and got it up and running, but am a little puzzled about how to actually...
  2. Oradam

    PL/SQL Revision Control

    Thanks guys, that was most helpful.
  3. Oradam

    PL/SQL Revision Control

    Hello All, Does anyone know of a software package or method that can be implemented in a development environment that will control the revisions of PL/SQL stored code in Oracle? I am kind of looking for a tool similar to CVS but that will adapt to Oracle. Thanks for your help! Adam
  4. Oradam

    Report won't refresh in WebIntelligence

    Hi all, I have a report that has about 10 prompts for user input when it runs that refreshes data just fine from the user client but when I try to refresh in WebI it gives me this in the frame where the prompts should be: <input type=hidden name=sEntry value=&quot; i am running 5.1.2, I...
  5. Oradam

    Can I display Run-time values in the report?

    another quick question for you - is there any way to take that value the user entered in and that i fetched from the UserResponse function and send it through an Oracle Stored Function? The user enters a number at report run-time and I need to look up the name associated with that number and...
  6. Oradam

    Can I display Run-time values in the report?

    Hi All, When my report runs, the user is asked to provide several pieces of data before the report generates. For instance, it will ask for a start month and an end month via the @Prompt(,,,,) method. Is there any way to then display the start and end months they chose in the report itself...
  7. Oradam

    Custom List of Values for an Object

    Hi all, Is there any way to have a list of values for a user to choose from at report runtime that displays one value but uses another in the actual query? This is entirely a performance issue. For example: Display list of values Data used in query January 1...
  8. Oradam

    BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB

    Yeah, the SQL works fine in SQLPlus, that's where we designed it. No luck in the universe preferences - I appreciate your help, though!
  9. Oradam

    BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB

    I'm not entirely sure you can call procedures that use OUT variables from BO. There are two ways to call procs (that I know of) from BO. You can do it through an Object, or use the BO reporting tool to directly call them (similar to the freehand SQL method). We call them through objects. Here...
  10. Oradam

    Any good software to develop PL/SQL in from Linux?

    Mike, Thanks for the suggestion, I'll probably do that. Sem, This program looks awesome, trying it out now - thanks for the link!
  11. Oradam

    BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB

    Trust me, we were just as surprised as BO's 'intuitiveness' on this one. I am primarily an Oracle developer that has been thrown on this task because of its database nature, therefore I am not as familiar with the inner-workings of BO. Can you suggest a tactic I could use to view or change...
  12. Oradam

    BO 5.1.1 / Oracle 8.1.7 Stored Procs Modifying DB

    Hi All, I'm running bo511 and oracle817 and have an object that calls a stored function in the SELECT section, passing other object values in. This stored function returns a numeric value based on the values passed into it and this value become one of the data columns for this object. When...
  13. Oradam

    Any good software to develop PL/SQL in from Linux?

    Hi all, I am a PL/SQL developer / assistant DBA and have always used the Quest software package SQL Navigator to maintain users, create packages, triggers, procedures, etc. It's a great package but they only make it for Windows. In lieu of Microsoft's new licensing scheme, among other...
  14. Oradam

    DBA...Job Opportunities

    midcareer, others on this forum may be able to provide a little more insight than I can, but I'll give you my spin. My career is just about to begin, I'm going to be a senior in college next year. I shared similar interests in the field and was drawn to Oracle. I interned last summer and...
  15. Oradam

    OCP Question

    I have encountered similar blatant errors in the Couchman book covering the 1st test. I am almost done with this book and will be taking the test next week sometime. It's no big deal when I find one that's wrong that I can easily identify based on my experience, but it worries me because on...

Part and Inventory Search

Back
Top