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...
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
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="
i am running 5.1.2, I...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.